Re: sorting dates
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22391
interpreted = N
texte = >>[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/
Associated Messages, from the most recent to the oldest:
>>[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/
PCS Technical Support
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:
off topic - dna snipets (1997)
Zipcodes (1998)
WebCatalog 4.0.2rc1 and rc2 crash WebSTAR on quit (2001)
[WebDNA] ImageMagick troubleshooting (2009)
Webstar 1.3.1 PPC (1997)
Omnibase db manipulation utility available as gift to Webcatalog community. (1999)
WebCat on Alpha? (1997)
Not really WebCat (1997)
RE: new cart IDs being assigned somehow (1997)
Using Plug-In while running 1.6.1 (1997)
sharing cookie recepies (1998)
orderfile and setlineitems (1998)
WebCat2 as a chat server? (1997)
UPPERCASE (1997)
createfolder not behaving as expected (1999)
Public beta 5 of WebCatalog 4.0 is now available (2000)
[listfiles] problems (1997)
Secure server question (1997)
Fedora Core 3 and WebDNA (2005)
SKU (1997)