Re: Crazy dates (was: Re: sorting dates)
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22454
interpreted = N
texte = I just tried the examples you sent on my machine and they show up properly:730130 730130 544952My 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? I also tried changing the read date preference to dmy and ymd and modified the dates appropriatly and the same (correct) numbers came up.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? > >>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 John A. Hill Pacific Coast Software eCommerce / Web Developer Tools http://www.smithmicro.com
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 544952My 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? I also tried changing the read date preference to dmy and ymd and modified the dates appropriatly and the same (correct) numbers came up.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? > >>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 John A. Hill Pacific Coast Software eCommerce / Web Developer Tools http://www.smithmicro.com
John Hill
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:
Null Chars (1999)
Bad Cookie (1998)
NewCart+Search with one click ? (1997)
More questions about serial number dishing (1997)
Date format problems (1997)
[WebDNA] Strange MATH result (2010)
Credit card types (1997)
WebMerchant and Mac Auth Hub Help Please (1999)
Re:quit command on NT (1997)
Sku numbers (1997)
Where is eudora plugin? (1998)
How To question on setting up downloads (1997)
Need some Java Script Code (2003)
Close Databases Crash? (1998)
[WebDNA] SEARCH question (2011)
restarting webcatalog (2002)
[Semi OT] HMAC_SHA1 (2006)
Huge databases and RAM (1998)
[shippingtotal] & Formulas.db prob (2003)
Cant get my own subtotal (2001)