Re: sorting dates
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22394
interpreted = N
texte = You could always try to put 93 days (3 months into the date field). I'vediscovered that it does work though it appears wrong (can't have a monthwith more than 31 days). I've used this one successfully...shop_browse.tpl?command=search&db=airways.db&cart=[cart]&max=3&DateEnteredtype=date&geDateEntereddatarq=[math date]{[date]}-{00/93/0000}[/math]Also I had to change a field because WebCat kept screwing up if I used[date] as a user-defined name. Ended up changing it to [DateEntered] andit works file.[search db=customers.db&datetype=date&rndatedata=[math][date][/math] [mathdate]{[date]}-{00/93/0000}[/math]][founditems][date] [name] [ipaddress] [email]
[/founditems]
[/search]Bill>>>[math date]{[date]}-{03/00/0000}[/math]>>>>I tried this and it returns 11/30/0000 no matter what I enter in the>>03/00/000 field.>>OK, you need to be sure your date format is mdy for this specific code to>work (open your WebCatalog Prefs file and see if ReadDateFormat has a>value of mdy, which stands for month/day/year).>>>asumming that I can get date -3 months, I think this could would work?>>>>[search db=customers.db&datetype=date&rndatedata=[math][date][/math] [math>>date]{[date]}-{00/03/0000}[/math]]>>[founditems]>>[date] [name] [ipaddress] [email]
>>[/founditems]
[/search]>>Yes, this looks reasonable. In order to prevent confusion, it's probably a>good idea to *not* have fields in databases named date because it can be>confused with WebDNA's [date] tag that returns today's date.>>Technical Support | ==== eCommerce and Beyond ====>Pacific Coast Software | WebCatalog, WebMerchant,>11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,>San Diego, CA 92128 | Typhoon>619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/--Bill Heissenbuttel PageHouse, Inc.bill@pagehouse.com Internet Presence Providerhttp://www.pagehouse.com (509) 892-1973
Associated Messages, from the most recent to the oldest:
You could always try to put 93 days (3 months into the date field). I'vediscovered that it does work though it appears wrong (can't have a monthwith more than 31 days). I've used this one successfully...shop_browse.tpl?command=search&db=airways.db&cart=
[cart]&max=3&DateEnteredtype=date&geDateEntereddatarq=[math date]{
[date]}-{00/93/0000}[/math]Also I had to change a field because WebCat kept screwing up if I used
[date] as a user-defined name. Ended up changing it to [DateEntered] andit works file.[search db=customers.db&datetype=date&rndatedata=
[math][date][/math] [mathdate]{
[date]}-{00/93/0000}[/math]]
[founditems][date] [name]
[ipaddress] [email]
[/founditems]
[/search]Bill>>>[math date]{
[date]}-{03/00/0000}[/math]>>>>I tried this and it returns 11/30/0000 no matter what I enter in the>>03/00/000 field.>>OK, you need to be sure your date format is mdy for this specific code to>work (open your WebCatalog Prefs file and see if ReadDateFormat has a>value of mdy, which stands for month/day/year).>>>asumming that I can get date -3 months, I think this could would work?>>>>[search db=customers.db&datetype=date&rndatedata=
[math][date][/math] [math>>date]{
[date]}-{00/03/0000}[/math]]>>
[founditems]>>
[date] [name]
[ipaddress] [email]
>>[/founditems]
[/search]>>Yes, this looks reasonable. In order to prevent confusion, it's probably a>good idea to *not* have fields in databases named date because it can be>confused with WebDNA's
[date] tag that returns today's date.>>Technical Support | ==== eCommerce and Beyond ====>Pacific Coast Software | WebCatalog, WebMerchant,>11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,>San Diego, CA 92128 | Typhoon>619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/--Bill Heissenbuttel PageHouse, Inc.bill@pagehouse.com Internet Presence Providerhttp://www.pagehouse.com (509) 892-1973
Bill Heissenbuttel
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:
[redirect] not working on NT? (1999)
WebCatalog/Mac 2.1b2 New Features (1997)
Emailer on NT CAN'T handle large email files (1997)
External RAID (2005)
Change in Host? (1999)
High ASCII inside [LOOKUP] inside [LISTWORDS] (1998)
[tcp connect] (1998)
WebCat2 several catalogs? (1997)
Search Folder? (1998)
# fields limited? (1997)
Multiple prices (1997)
Couple of questions (1999)
Surprise x and y post args (1998)
I'm new be kind (1997)
webdelivery.html and webna (1997)
SKU (1997)
Setting up shop (1997)
WebCatalog 2.1b3 - Plugin or cgi ? (1997)
formatting dates from a field ... (1997)
The beginning (1997)