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:

    
  1. Re: Sorting Dates in a search (Nico 2000)
  2. Sorting Dates in a search (Eric Palhof 2000)
  3. Sorting Dates (Eric palhof 2000)
  4. Re: Crazy dates (was: Re: sorting dates) (Christer Olsson 1999)
  5. Re: Crazy dates (was: Re: sorting dates) (Martin Bech 1999)
  6. Re: Crazy dates (was: Re: sorting dates) (John Hill 1999)
  7. Crazy dates (was: Re: sorting dates) (Christer Olsson 1999)
  8. Re: sorting dates (Kenneth Grome 1999)
  9. Re: sorting dates (bradeisenberg@iname.com 1999)
  10. Re: sorting dates (Bill Heissenbuttel 1999)
  11. Re: sorting dates (Bill Heissenbuttel 1999)
  12. Re: sorting dates (PCS Technical Support 1999)
  13. Re: sorting dates (bradeisenberg@iname.com 1999)
  14. Re: sorting dates (PCS Technical Support 1999)
  15. sorting dates (bradeisenberg@iname.com 1999)
  16. sorting dates (bradeisenberg@iname.com 1999)
  17. sorting dates (bradeisenberg@iname.com 1999)
  18. Re: Searching/sorting dates (Grant Hulbert 1997)
  19. Searching/sorting dates (Christer Olsson 1997)
>>[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)