Re: Do the [date] thing...

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39688
interpreted = N
texte = >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???Yes. Start with calculate a start date and and end date for the week, and the nsearch for dates within that range (assuming you have your date prefs configured in the same way as the dates in the db are stored). -- ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Idéer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se------------------------------------------------------------- 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 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???Yes. Start with calculate a start date and and end date for the week, and the nsearch for dates within that range (assuming you have your date prefs configured in the same way as the dates in the db are stored). -- ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Idéer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se------------------------------------------------------------- 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/ Christer Olsson

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:

Other tags inside the founditems context? (1998) Search design (1997) Version 4? (2000) redirect strangeness (2000) Problem (1997) Where is f2? (1997) WebCat2 - Getting to the browser's username/password data (1997) OT: Calling All Freelance Programmers in PDX (2000) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) WebCat2 - [format thousands] (1997) 2cd pare of eyes. (2001) Setting up shop (1997) A quickie question (1997) Not really WebCat (1997) [WebDNA] Adding bcrypt as a encryption / hashing option (2017) Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997) [OT] DOD again (2003) WebDNA-Talk Digest mode broken (1997) WebCat B13 Mac CGI -- Frames question (1997) simple answer? [hideif] (1997)