Re: Newbie search question (between two dates)

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39478
interpreted = N
texte = In Ken's absence, I'll have to advocate storing ALL dates as days since 00/00/0000. This makes searching and sorting much easier down the road.Store dates in your database like this... EVENTDATE=[math]{[date]}[/math] Do the math to find the date 2 weeks from today... [text]Today=[math]{[date]}[/math][/text] (Result: 731142) [text]2Weeks=[math][Today]+14[/math][/text] (Result: 731156) Search like this... [search db=norcalendar.db&rnEVENTDATEdatarq=[Today]+[2Weeks]&EVENTDATEsort=1&EVENTDATEtype=num]>[search db=norcalendar.db&rneventdatedatarq=[date] [math >date]{[date]}+14[/math]&eventdatetype=date&eventdatesort=1] > >Thanks everyone, This is what I ended up with. > > >-- >Matthew C. Bohne >-- >The Sandusky Register >314 W. Market St. >Sandusky, OH 44870 >(800) 466-1243 ext. 253 >matthewbohne@sanduskyregister.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: Newbie search question (between two dates) (Kenneth Grome 2001)
  2. Re: Newbie search question (between two dates) (Clint Davis 2001)
  3. Re: Newbie search question (between two dates) (Matthew Bohne 2001)
  4. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  5. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  6. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  7. Re: Newbie search question (between two dates) (Brian Fries 2001)
  8. Re: Newbie search question (between two dates) (Brian Fries 2001)
  9. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  10. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  11. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  12. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  13. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  14. Newbie search question (between two dates) (Matthew Bohne 2001)
In Ken's absence, I'll have to advocate storing ALL dates as days since 00/00/0000. This makes searching and sorting much easier down the road.Store dates in your database like this... EVENTDATE=[math]{[date]}[/math] Do the math to find the date 2 weeks from today... [text]Today=[math]{[date]}[/math][/text] (Result: 731142) [text]2Weeks=[math][Today]+14[/math][/text] (Result: 731156) Search like this... [search db=norcalendar.db&rnEVENTDATEdatarq=[Today]+[2Weeks]&EVENTDATEsort=1&EVENTDATEtype=num]>[search db=norcalendar.db&rneventdatedatarq=[date] [math >date]{[date]}+14[/math]&eventdatetype=date&eventdatesort=1] > >Thanks everyone, This is what I ended up with. > > >-- >Matthew C. Bohne >-- >The Sandusky Register >314 W. Market St. >Sandusky, OH 44870 >(800) 466-1243 ext. 253 >matthewbohne@sanduskyregister.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:

[WebDNA] RESTART WebDNA (2016) Running WebCat from a CD-ROM (1997) 2.1b3 --> way slow (1997) Date Range search (1997) WebCommerce: Folder organization ? (1997) RE: Can a database get stomped by simultaneous access? (1997) A little syntax help (1997) Writing to PDF (2003) Error: the 'showcart' command requires that you specify a db (1997) New commands in Final candidate (1997) [ShowIf] a either fields are blank (1998) Exclamation point (1997) DD/MM/YY reseting (1999) The EMailer and the Blank menu bar? (1999) suggestions for a good text editor on windows? (2005) service stop and restart (1997) TPC Connect (1999) Quick ShowIf question (1997) select multiple (1997) PCS Frames (1997)