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:

    
  1. Re: date pref (Kenneth Grome 1999)
  2. Re: date pref (Kenneth Grome 1999)
  3. Re: date pref (Mícheál O Sé 1999)
  4. Re: date pref (webcat 1999)
  5. Re: date pref (Kenneth Grome 1999)
  6. Re: date pref (Mícheál O Sé 1999)
  7. Re: date pref (Mícheál O Sé 1999)
  8. Re: date pref (Mícheál O Sé 1999)
  9. Re: date pref (Mícheál O Sé 1999)
  10. Re: date pref (Kenneth Grome 1999)
  11. Re: date pref (Christer Olsson 1999)
  12. date pref (Mícheál O Sé 1999)
  13. RE:math context ignores date prefs? (John Hill 1998)
  14. math context ignores date prefs? (Matthias Precht 1998)
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)