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=date Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines 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:

    
  1. date comparison demo page ( Terry Wilson 2004)
  2. Re: Date comparison using showif (Robert Wade 2003)
  3. Re: Date comparison using showif (WebDna @ 2003)
  4. Re: Date comparison using showif (Brian Fries 2003)
  5. Re: Date comparison using showif (Dale's Stuff 2003)
  6. Re: Date comparison using showif (WebDna @ 2003)
  7. Re: Date comparison using showif (Donovan home EHG 2003)
  8. Re: Date comparison using showif (WebDna @ 2003)
  9. Re: Date comparison using showif (Donovan home EHG 2003)
  10. Re: Date comparison using showif (Donovan home EHG 2003)
  11. Re: Date comparison using showif (WebDna @ 2003)
  12. Date comparison using showif (Robert Wade 2003)
  13. Re: Date Comparison (Kenneth Grome 2003)
  14. Re: Date Comparison (without mistake) (Charles Kline 2003)
  15. Re: Date Comparison (Charles Kline 2003)
  16. Re: Date Comparison (Paul Berman 2003)
  17. Re: Searching by Date Comparison (John Butler 2000)
  18. Re: Searching by Date Comparison (Kim Ingram 2000)
  19. Re: Searching by Date Comparison (Jason Sofonia 2000)
  20. Searching by Date Comparison (Kim Ingram 2000)
  21. Re: Date Comparison (PCS Technical Support 1998)
  22. Re: Date Comparison (Kenneth Grome 1998)
  23. Date Comparison (Daniel Rogers 1998)
  24. Date comparison has serious bug ... (Kenneth Grome 1998)
  25. Date comparison (I think) has bugs ... (Kenneth Grome 1998)
  26. Re: webcat2b12 CGI -- Date comparisons (Kenneth Grome 1997)
  27. webcat2b12 CGI -- Date comparisons (Grant Hulbert 1997)
>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=date Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines 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)