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 730130544952My 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 SoftwareeCommerce / 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 730130544952My 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 SoftwareeCommerce / 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:

WebCat2: Items xx to xx shown, etc. (1997) problems with 2 tags (1997) Re2: frames & carts (1997) Getting Emailer to send mail (1997) Summary search -- speed (1997) Sorting by date (1997) ReturnRaw Returns (2000) no global [username] or [password] displayed ... (1997) vars (2000) TaxTotal Problem (1997) Text data with spaces in them... (1997) Entry pages (was: WebCatalog MAJOR drawback) (1998) Linux WebCatalog on Apache w/ Raven SSL (2000) rename a file (1997) Searching multiple fields (1997) WebMerchant when CC network is down (1998) Ampersand (1997) .htaccess to make WebDNA serve HTML (2007) Advice on MacOS & TCP Connects (2000) [WebDNA] WebDNA move issue (2011)