Re: sorting dates
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22395
interpreted = N
texte = You could always try to put 93 days (3 months into the date field). I've discovered that it does work though it appears wrong (can't have a month with more than 31 days). I've used this one successfully...shop_browse.tpl?command=search&db=airways.db&cart=[cart]&max=3&DateEnteredty pe=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] and it works file.[search db=customers.db&datetype=date&rndatedata=[math][date][/math] [math date]{[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 Provider http://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've discovered that it does work though it appears wrong (can't have a month with more than 31 days). I've used this one successfully...shop_browse.tpl?command=search&db=airways.db&cart=
[cart]&max=3&DateEnteredty pe=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] and it works file.[search db=customers.db&datetype=date&rndatedata=
[math][date][/math] [math date]{
[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 Provider http://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:
WebCatalog and WebTen (1997)
Nesting format tags (1997)
Emailer error 571 (1998)
Updating a database once per day - An example (1998)
da webcat, da merchant, da auth (1998)
Expert tech support -- a fast and simple solution (long) ... (2000)
AutoReload? RequireComment? InterpretAll? (1999)
Follow-Up to: Removing [showif] makes a big difference in speed (1997)
Reverse text string (2002)
How To question on setting up downloads (1997)
Showif for mulitple variations (1997)
[countWords]? (1997)
Multiple security dbs (1997)
OT - New Ti Books (2002)
corrupted images (2002)
2nd Request for help/advice on variable pricing (2000)
delete after x (1998)
Protect (1997)
2nd WebCatalog2 Feature Request (1996)
WebMerchant Processing criteria for AuthorizeNet (2000)