Date Comparison

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17240
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. [Search db=shops.db&eqshowdata=Y&createdtype=date&gecreateddata=[format Days_To_Date %d/%m/%Y][math]{[date %m/%d/%Y]}-2[/math][/format]&createdsort=1&namesort=2&allreqd=T]Where created is the created date in the format dd/mm/yyyy. Am I doing something wrong? it appears bring up the corect date from the math?Can anyone help?TIADanDaniel Rogers ---------------------------------------------------------------------- NetCommerce http://www.NetCommerce.co.uk ---------------------------------------------------------------------- Tel: +44 (0)1703 450400 Fax: +44 (0)1703 450451 ---------------------------------------------------------------------- Email address : drogers@NetCommerce.co.uk ---------------------------------------------------------------------- Buy It On-Line in 98! http://www.ShopsOnTheNet.co.uk http://www.ShopsOnTheNet.com ---------------------------------------------------------------------- InfoDisk - Address and Telephone Numbers for over 44 million UK residents on CD-Rom Order Your Copy Now from IDDirect! http://www.iddirect.co.uk ---------------------------------------------------------------------- Europe's Premier On-Line CD Rom Retailer http://www.CDDirect.co.uk 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. [Search db=shops.db&eqshowdata=Y&createdtype=date&gecreateddata=[format Days_To_Date %d/%m/%Y][math]{[date %m/%d/%Y]}-2[/math][/format]&createdsort=1&namesort=2&allreqd=T]Where created is the created date in the format dd/mm/yyyy. Am I doing something wrong? it appears bring up the corect date from the math?Can anyone help?TIADanDaniel Rogers ---------------------------------------------------------------------- NetCommerce http://www.NetCommerce.co.uk ---------------------------------------------------------------------- Tel: +44 (0)1703 450400 Fax: +44 (0)1703 450451 ---------------------------------------------------------------------- Email address : drogers@NetCommerce.co.uk ---------------------------------------------------------------------- Buy It On-Line in 98! http://www.ShopsOnTheNet.co.uk http://www.ShopsOnTheNet.com ---------------------------------------------------------------------- InfoDisk - Address and Telephone Numbers for over 44 million UK residents on CD-Rom Order Your Copy Now from IDDirect! http://www.iddirect.co.uk ---------------------------------------------------------------------- Europe's Premier On-Line CD Rom Retailer http://www.CDDirect.co.uk Daniel Rogers

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:

Listfiles on network with NT (2000) WebCat2b13MacPlugIn - syntax to convert date (1997) Drop Down Menus (2002) Interfacing WebMerchant to www.fedex.com (1997) WebCat 4.0 (2000) Which GUI HTML editors work with WC ? (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) Removing [showif] makes a big difference in speed (1997) Server crash (1997) splitting up items in a cart (1999) Authenticate (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) WebCommerce: Folder organization ? (1997) Can this be done? (1997) Adding Message to Order (1997) NetSplat and WebCat2 (1997) 2nd WebCatalog2 Feature Request (1996) proper way to check if a container is empty? (2000) Using Applescript to process WebCatalog functions (1998) Setting up shop (1997)