Re: Do the [date] thing...

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39693
interpreted = N
texte = I mentioned this last week, but here goes again...Your best bet on storing dates is to use the days since 00/00/0000 method. Check the archives for my post from last week. Ken Grome also made several posts relating to this topic.Doing it this way makes it so much easier to search and/or manipulate dates later on. >I need to find all records in a database which has a date in a specific >week. > >In the database i have stored the date as yyyy/mm/dd but now i need to find >all records whose date is in say week 43... > >Can this be done??? > >---------------------- > Jimmi Kristensen > WebDNA Developer > jimmi@euroteam.com > http://euroteam.com >------------------------ _______________________Clint Davis Webmaster Gray Loon Marketing Group 812.422.9999cdavis@grayloon.com------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Do the [date] thing... (Glenn Busbin 2001)
  2. Re: Do the [date] thing... (Clint Davis 2001)
  3. Re: Do the [date] thing... (Christer Olsson 2001)
  4. Do the [date] thing... (Jimmi Kristensen 2001)
I mentioned this last week, but here goes again...Your best bet on storing dates is to use the days since 00/00/0000 method. Check the archives for my post from last week. Ken Grome also made several posts relating to this topic.Doing it this way makes it so much easier to search and/or manipulate dates later on. >I need to find all records in a database which has a date in a specific >week. > >In the database i have stored the date as yyyy/mm/dd but now i need to find >all records whose date is in say week 43... > >Can this be done??? > >---------------------- > Jimmi Kristensen > WebDNA Developer > jimmi@euroteam.com > http://euroteam.com >------------------------ _______________________Clint Davis Webmaster Gray Loon Marketing Group 812.422.9999cdavis@grayloon.com------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Clint Davis

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

searching with groups (1997) Table sorting by selected category then others (2004) OT: SEO (2007) Mixing and/or in searches (1998) ugly math date (2002) Bad URL reference? (1997) Re:WebCatalog f2 Installation (1997) WebCat2: Items xx to xx shown, etc. (1997) File Upload and Platform (2001) MATH PROBLEM (1997) Sorting when searching with grouped fields (2002) [searchString] (1997) TeaRoom Order fields email account remain empty even thoughthewy are filled. (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) [OT] HTML EMAIL program wanted (1999) Bug Report, maybe (1997) [OT] XServe networking PITA (2004) MacWEEK article help needed (1996) Help name our technology! (1997) Part 2 - [showif] if variable exists (1998)