Re: date pref

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24030
interpreted = N
texte = >>>>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. Well that is fine Ken but what if you are given a database with a date field already in the form of dd/mm/yyyy. How do you convert a 3000 odd .db to number of days since 0000?:-))Regards, **************************************************************** Micheal O Se www.elive.ie Internet Hosting Service micheal@elive.ie Database powered websites **************************************************************** 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)
>>>>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. Well that is fine Ken but what if you are given a database with a date field already in the form of dd/mm/yyyy. How do you convert a 3000 odd .db to number of days since 0000?:-))Regards, **************************************************************** Micheal O Se www.elive.ie Internet Hosting Service micheal@elive.ie Database powered websites **************************************************************** Mícheál O Sé

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:

Hierarchy of form/text/math variables (renamed thread) (2000) [group] ? (1997) presetting variables ... (2000) [WebDNA] inputed text getting scrambled up in DB (2012) Passing variables to Realm Authentication - WebStar (1998) problems with 2 tags (1997) BIG PROBLEMS with Checkboxes!!! (1998) searchable list archive (1997) Help! WebCat2 bug (1997) Founditems context returning only 1 item (1997) User / Pass in TCP connect (2007) Separate SSL Server (1997) Order not created error (never mind) (1997) emailer (1997) Uh...can someone help me out with the b10? (1997) [BoldWords WordList]Any Text[/BoldWords] (2000) [cart] not being interpreted inside [founditems] (1997) Cart Template (1997) Formating Tables w/[founditems] (1998) Associative lookup style? + bit more (1997)