Re: Date Comparison
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47523
interpreted = N
texte = >Hi>>I am trying unsucessfully to compare the current date 6/2/2003 with the>start and end dates of an offer>>my start and end date format is the same as the current date but for some>reason I just cant get this working, I have searched the archives but found>little to help me there.>>My fields are Startdate and enddate and all I need is to endsure that the>current date is equal or after the start date and the current date is either>before or equal to the end date.Use all 4 of these parameters in your search:&lestartdatedatarq=[currentDate]&geenddatedatarq=[currentDate]&startdatetype=date&enddatetype=dateSincerely,Kenneth Grome---------------------------------------------------WebDNA Professional Training and Development Center175 J. Llorente Street +63 (32) 255-6921Cebu City, Cebu 6000 kengrome@webdna.netPhilippines http://www.webdna.net----------------------------------------------------------------------------------------------------------------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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>Hi>>I am trying unsucessfully to compare the current date 6/2/2003 with the>start and end dates of an offer>>my start and end date format is the same as the current date but for some>reason I just cant get this working, I have searched the archives but found>little to help me there.>>My fields are Startdate and enddate and all I need is to endsure that the>current date is equal or after the start date and the current date is either>before or equal to the end date.Use all 4 of these parameters in your search:&lestartdatedatarq=[currentDate]&geenddatedatarq=[currentDate]&startdatetype=date&enddatetype=dateSincerely,Kenneth Grome---------------------------------------------------WebDNA Professional Training and Development Center175 J. Llorente Street +63 (32) 255-6921Cebu City, Cebu 6000 kengrome@webdna.netPhilippines http://www.webdna.net----------------------------------------------------------------------------------------------------------------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://webdna.smithmicro.com/
Kenneth Grome
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:
NT Manual (1997)
authenticating a second user (1997)
Re:[off] Promotions Co? (1997)
Site Search Concepts (2003)
PIXO Support (1997)
PSC recommends what date format yr 2000??? (1997)
[delete] problem (1997)
Error Type 3 (1999)
SIMS setup (1998)
Sku numbers (1997)
[SearchString] usage (1997)
info (1997)
WebCat2final1 crashes (1997)
search not executing from a post, but works fine with (2004)
emailer on Windows Beta 18 (1997)
WebCatalog Features (1997)
Help! WebCat2 bug (1997)
Text data with spaces in them... (1997)
Robert Minor duplicate mail (1997)
CAll me Crazy (2000)