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:

Trouble installing WebCat on OSX apache .. (2001) Web Catalog and Net Cloak (1998) The text on this page exceeds 1 MB in length error (2000) Banner DNA (1997) converting tabs (1997) suffix mapping for NT? (1997) ANother SHOWIF problem (1997) Thanks and Big News!!! (1997) virtual virtual hosted store.... (1998) webcat 2.1 new cart fields - please explain more (1998) policies, slightly OT (2004) Just Testing (1997) domain in cookie (2006) WebCatalog can't find database (1997) Searchable WebCat (etc.) Docs ? (1997) Help name our technology! I found it (1997) Database Strategy - more... (1998) CommandSecurity? (1997) Change extension (2000) is 'template' a reserved webcat tag? (2000)