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:

Thanks Grant (1997) Download URL & access on the fly ? (1997) Highlighting words found in a keyword search (2003) Robert Minor duplicate mail (1997) The USArea® Network web site ... (1997) Exposure Opportunity....! (1999) bug in [SendMail] (1997) Problem displaying search result (1997) Newbie trouble with [url] & [foundItems] (2000) WebCommerce: Folder organization ? (1997) RE: Loss in form (1998) Multiple 'Users.db' files not possible (1997) Shopping Cart Questions (1998) object tag examples (2004) F3 crashing server (1997) GuestBook example (1997) Thanks ! (1997) username's and passwords in uppercase vs lowercase vs mix. (2000) Price + Texte (1999) CSS problem (2000)