Re: sorting dates

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 22397
interpreted = N
texte = I seem to be having trouble with whole date fomrat thing.The prefrences is set to MM/DD/YYYY. when I enter [date], I get 01/07/99 when I enter [math]{[date]}[/math] I get 694325 now this is supposed to be days since 00/00/0000 but 694325 days since then is 1902, not 1999.theoritically this [math date]{[date]}-{03/00/0000}[/math] should give me 694295, but it gives me 11/30/0000.I'm kinda confused here.> >>[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). > --------------------------------------------------------- Get free personalized email at http://geocities.iname.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)
I seem to be having trouble with whole date fomrat thing.The prefrences is set to MM/DD/YYYY. when I enter [date], I get 01/07/99 when I enter [math]{[date]}[/math] I get 694325 now this is supposed to be days since 00/00/0000 but 694325 days since then is 1902, not 1999.theoritically this [math date]{[date]}-{03/00/0000}[/math] should give me 694295, but it gives me 11/30/0000.I'm kinda confused here.> >>[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). > --------------------------------------------------------- Get free personalized email at http://geocities.iname.com bradeisenberg@iname.com

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:

Templates on Unix & CGI on Mac? (1997) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) authorizenet and netscape (2002) Automatic Download? (2003) Problem with empty form-variables in [search] (1998) I can help! (1996) [BULK] RE: [WebDNA] [BULK] WebDNA Windows Install (2016) Math with Time (1997) OT: Prevent Caching js Files (2003) Stinkin' [Referrer] (1998) 301 redirect (2008) Re:Add (1998) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) webCatalog and Stocks (1998) .htaccess to make WebDNA serve HTML (2007) Multiple catalog databases and showcart (1997) WebCat2b15MacPlugin - showing [math] (1997) [SearchString] usage (1997) WebCatalog Hosting (1996) Search wbrk word break param (1998)