Re: Crazy dates (was: Re: sorting dates)
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22465
interpreted = N
texte = >I just tried the examples you sent on my machine and they show up properly: > >730130 >730130 >544952 > >My read date format is mdy and display preference is %m/%d/%Y. There is >something else wrong with your setup that is more fundamental I believe. >The number of days you're getting back is 12/31/1900. What platform are >you on and which version of WebCatalog?Mac and WC 3.0.1. Upgrading to 3.0.3 made this problem disappear. I haven't seen any announcement of that release, so therefore wasn't the upgrade made.>I also tried changing the read date preference to dmy and ymd and modified >the dates appropriatly and the same (correct) numbers came up.Did work here, too. But I found out something I don't think I've seen before: I had to restart Web* for making the change to happen - setting the preference wasn't enough.>John. > >>Until now I haven't paid much attention to this, since WebCat always has >>had problems with the date format we use in Sweden (YYYY-MM-DD). We have >>developed a few workarounds to avoid the problems, but it *is* clumsy to >>not beeing able to use our native way to write dates. >> >>When I saw the YYYY-MM-DD in the read date prefs I started to experiment, >>and it does not look good at all. >> >>Our prefs is set to date display format %m/%d/%Y and read date format to >>mdy. >> >>[math]{[date]}[/math] displays 694325 >>[math]{01/11/1999}[/math] displays 694325 >>[math]{01/11/1492}[/math] displays 694325 >> >>as a matter of fact any date I enter displays 694325. >> >>I have also experimented to set date display format to %Y-%m-%d and read >>date format to ymd. It shows other figures, but not the right ones. >> >>Are we supposed to be able to both display and do [math] on YYYY-MM-DD dates?You didn't answer this one, but it seems to work with [math] on YYYY-MM-DD dates now, too (and this is really *GOOD* news to us, thanks!). The only non-working thing I have observed is that the result of such a calculation is still a US formatted date:[MATH date]{[DATE]}-{0000-00-11}[/MATH] displays 12/31/1998Date display format is set to %Y-%m-%d (and read date format to ymd) so IMO it should display 1998-12-31.>>>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). ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Ideer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se
Associated Messages, from the most recent to the oldest:
>I just tried the examples you sent on my machine and they show up properly: > >730130 >730130 >544952 > >My read date format is mdy and display preference is %m/%d/%Y. There is >something else wrong with your setup that is more fundamental I believe. >The number of days you're getting back is 12/31/1900. What platform are >you on and which version of WebCatalog?Mac and WC 3.0.1. Upgrading to 3.0.3 made this problem disappear. I haven't seen any announcement of that release, so therefore wasn't the upgrade made.>I also tried changing the read date preference to dmy and ymd and modified >the dates appropriatly and the same (correct) numbers came up.Did work here, too. But I found out something I don't think I've seen before: I had to restart Web* for making the change to happen - setting the preference wasn't enough.>John. > >>Until now I haven't paid much attention to this, since WebCat always has >>had problems with the date format we use in Sweden (YYYY-MM-DD). We have >>developed a few workarounds to avoid the problems, but it *is* clumsy to >>not beeing able to use our native way to write dates. >> >>When I saw the YYYY-MM-DD in the read date prefs I started to experiment, >>and it does not look good at all. >> >>Our prefs is set to date display format %m/%d/%Y and read date format to >>mdy. >> >>
[math]{
[date]}[/math] displays 694325 >>
[math]{01/11/1999}[/math] displays 694325 >>
[math]{01/11/1492}[/math] displays 694325 >> >>as a matter of fact any date I enter displays 694325. >> >>I have also experimented to set date display format to %Y-%m-%d and read >>date format to ymd. It shows other figures, but not the right ones. >> >>Are we supposed to be able to both display and do
[math] on YYYY-MM-DD dates?You didn't answer this one, but it seems to work with
[math] on YYYY-MM-DD dates now, too (and this is really *GOOD* news to us, thanks!). The only non-working thing I have observed is that the result of such a calculation is still a US formatted date:[MATH date]{
[date]}-{0000-00-11}[/MATH] displays 12/31/1998Date display format is set to %Y-%m-%d (and read date format to ymd) so IMO it should display 1998-12-31.>>>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). ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Ideer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se
Christer Olsson
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:
WebCat and image maps (1997)
WebMerchant - MacAuthorize (1999)
CHMOD recursive for directories (2006)
WebDNA - fun to compare (2005)
How About Credit Card Transactions (1998)
Sendmail Woes (2002)
WebCat2b15MacPlugin - showing [math] (1997)
[WebDNA] User sessions - cookies only or cookies and a sessions.db? (2016)
snicker, snicker (1997)
Buying sans cart (1997)
WebDelivery downloads alias, not original ? (1997)
[OT] Bad Hard Drive? (2003)
Problems setting MIME Headers (1998)
Finding max value for a field (1997)
Open Market's Transact & Macintosh (1998)
[WriteFile] problems (1997)
where to put code (1998)
[OT] RedHat - GNOME (2004)
WebCat2 - Getting to the browser's username/password data (1997)
Replacing a Word (1999)