Re: Date Comparison

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17251
interpreted = N
texte = >Is webcatalog able to compare dates in the dd/mm/yyyy format? I'm trying >to show a list of less than two day old items on a site in the UK and >this search does not seem to be working.If your DateFormat value (in the WebCatalog Prefs) is set to create dates in dd/mm/yyyy format -- *and* if the dates in your database conform to that format as well -- then according to the HTML docs, all your date comparisons will work properly ...But if your DateFormat in the prefs is different from the date format of the values you're trying to compare, WebCat will NOT be able to compare them properly.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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)
>Is webcatalog able to compare dates in the dd/mm/yyyy format? I'm trying >to show a list of less than two day old items on a site in the UK and >this search does not seem to be working.If your DateFormat value (in the WebCatalog Prefs) is set to create dates in dd/mm/yyyy format -- *and* if the dates in your database conform to that format as well -- then according to the HTML docs, all your date comparisons will work properly ...But if your DateFormat in the prefs is different from the date format of the values you're trying to compare, WebCat will NOT be able to compare them properly.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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:

WebCat2.0b15-to many nested [xx] tags (1997) How can I record purchases to a database? (1998) [BULK] [WebDNA] [BULK] WebDNA 7 - Ready or Not ?? I'm not sure... (2011) Erotic Sites (1997) Search inside Include (1998) Pithy questions on webcommerce & siteedit (1997) Duplicate Messages (1998) [WebDNA] A new popuated field to a DB with 700.000 records (2009) Converting SQL Microtime to Date and Time (2003) WebCatalog Plugin: Getting Data Canceled (2000) My new discussion forum (2003) Dang... Sorry, WebDNA server not running (again)? (2003) Need help... (1997) replacing founditems ... (2002) Multiple cart additions (1997) 1st Comparison inside [fileinfo] broken. = bug? (2004) Email notification to one of multiple vendors ? (1997) Shipping based in distance and weight (1999) Show shoppingcart after remove last item (1997) Sending order notification by fax (1999)