Re: date pref
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24029
interpreted = N
texte = Ken,Any way to take dates that are already formatted in mm/dd/yyyy format to number of days format? I have a large database with dates formatted this way. I have heard mentioned before from people that the 'number of days' is a better way to go, but I have all this data already in the database.Thanks>>>>I think you should change the Read date format, too.>>>>i also did that Ken. Quit W* and diit with BBEdit.Still no joy.>>>Well, I cannot say that I'm surprised, webcat seems to always have some >kind of problem with dates ...>>A long time ago I changed over to storing my dates as the number of days >since 0000. Now when I make date comparisons, I'm comparing numbers, not >formatted date values, so the comparisons are far faster than ever before >-- and they always work as expected. Formatting dates on the page is done >on the fly wherever needed.>>Sincerely,>Kenneth Grome>WebDNA Consultant>>>>>
Associated Messages, from the most recent to the oldest:
Ken,Any way to take dates that are already formatted in mm/dd/yyyy format to number of days format? I have a large database with dates formatted this way. I have heard mentioned before from people that the 'number of days' is a better way to go, but I have all this data already in the database.Thanks>>>>I think you should change the Read date format, too.>>>>i also did that Ken. Quit W* and diit with BBEdit.Still no joy.>>>Well, I cannot say that I'm surprised, webcat seems to always have some >kind of problem with dates ...>>A long time ago I changed over to storing my dates as the number of days >since 0000. Now when I make date comparisons, I'm comparing numbers, not >formatted date values, so the comparisons are far faster than ever before >-- and they always work as expected. Formatting dates on the page is done >on the fly wherever needed.>>Sincerely,>Kenneth Grome>WebDNA Consultant>>>>>
webcat
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:
More on the email templates (1997)
Running _every_ page through WebCat ? (1997)
Can this be done? (1997)
CMSBuilder (2004)
Admin User - Users.db (1999)
Ampersand in XHTML Code - Not Valid (2005)
Dealer Locator (2008)
How do I send a 404 HTTP header ? (2004)
Database changes (1998)
Using WebMerchant Only? (1998)
[WebDNA] Authorize working connection... (2020)
webcat- multiple selection in input field (1997)
[Announce]: Web server security and password protection (1997)
Now when I send TeaRoom Order fields it does not post in Invoice. (1997)
[WebDNA] Admin Login Required to Serve any TPL Page (2009)
Spiders (1998)
[OT] html background att (2003)
Fun with dates (1997)
Web Catalog vs. ICAT (1997)
Hideif on IP range (2004)