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 DavisWebmasterGray Loon Marketing Group812.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:
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 DavisWebmasterGray Loon Marketing Group812.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:
Classifieds (2000)
Terry's formvariables tip (1998)
Conveting Characters to Graphics (1997)
[REPLACE] inside [FOUNDITEMS] (1998)
Can't Update records (1997)
To Use Cookies or Not To Use Cookies (2003)
Setting up WebCatalog with Retail Pro data (1996)
Extended [ConvertChars] (1997)
Max Record length restated as maybe bug (1997)
WebCat2: Items xx to xx shown, etc. (1997)
ShowNext Command (1997)
Almost a there but..bye bye NetCloak (1997)
Restricting to one folder hierarchy on the entire server (2005)
[WebDNA] SkipJack Question (2009)
RE: WebCat and image maps (1997)
Auto entering Friday's date in a field (2002)
Show if file exists (2004)
Frames and WebCat (1997)
Configuring E-mail (1997)
Banner Ad example (Typhoon) and WebCatalog (1997)