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----------------------------------------------------------------------NetCommercehttp://www.NetCommerce.co.uk----------------------------------------------------------------------Tel: +44 (0)1703 450400Fax: +44 (0)1703 450451----------------------------------------------------------------------Email address : drogers@NetCommerce.co.uk----------------------------------------------------------------------Buy It On-Line in 98!http://www.ShopsOnTheNet.co.ukhttp://www.ShopsOnTheNet.com----------------------------------------------------------------------InfoDisk - Address and Telephone Numbersfor over 44 million UK residents on CD-RomOrder Your Copy Now from IDDirect!http://www.iddirect.co.uk----------------------------------------------------------------------Europe's Premier On-Line CD Rom Retailerhttp://www.CDDirect.co.uk
Associated Messages, from the most recent to the oldest:
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----------------------------------------------------------------------NetCommercehttp://www.NetCommerce.co.uk----------------------------------------------------------------------Tel: +44 (0)1703 450400Fax: +44 (0)1703 450451----------------------------------------------------------------------Email address : drogers@NetCommerce.co.uk----------------------------------------------------------------------Buy It On-Line in 98!http://www.ShopsOnTheNet.co.ukhttp://www.ShopsOnTheNet.com----------------------------------------------------------------------InfoDisk - Address and Telephone Numbersfor over 44 million UK residents on CD-RomOrder Your Copy Now from IDDirect!http://www.iddirect.co.uk----------------------------------------------------------------------Europe's Premier On-Line CD Rom Retailerhttp://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)