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:
Help! WebCat2 bug (1997)
carriage returns in data (1997)
Suggestion: appendfounditems (2002)
Summing fields (1997)
This message couldn't reach the list! (multi-column (1998)
Some Advise needed (1997)
New public beta available (1997)
[shownext] and descending order (1997)
Problem with updating to 2.1.1 (1998)
Suggestions on best way to work with yyyy/mm/dd (1997)
Just Testing (1997)
emailer setup (1997)
ShowNext (1997)
Upgrading old WebCat Database Files (1997)
Include vs. lookup? (1998)
WebCat cannot handle compatible search parameters? (1997)
price carry over (1997)
RE: Credit card processing - UK (1997)
pc (1997)
WebCat BeOS (2002)