Re: date pref

This WebDNA talk-list message is from

1999

It keeps the original formatting. numero = 24035
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.>>>>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?:-))M#237#che#225#l, let's assume your db is named xxx.db ... and that the fieldDate field is the one that's currently storing your dates in your dd/mm/yyyy format ... and you have a sku field in that db with a unique value in it for each record in the db. This is how I would do it:1- Quit webcat.2- Make a copy of your db for backup, just in case ...3- Change your DateFormat pref to %m/%d/%Y via BBEdit.4- Change your ReadDateFormat pref to mdy via BBEdit.5- Launch webcat.6- Run this webdna code ONLY ONCE:[search db=xxx.db&neskudatarq=[blank]][founditems][replace db=xxx.db&eqskudatarq=[sku]]fieldDate=[math]{[getchars start=4&end=6][fieldDate][/getchars][getchars start=1&end=3][fieldDate][/getchars][getchars start=7&end=10][fieldDate][/getchars]}[/math][/replace][/founditems][/search]Sincerely,Kenneth GromeWebDNA Consultant Associated Messages, from the most recent to the oldest:

Re: date pref (Kenneth Grome 1999)
Re: date pref (Kenneth Grome 1999)
Re: date pref (M�che�l O S� 1999)
Re: date pref (webcat 1999)
Re: date pref (Kenneth Grome 1999)
Re: date pref (M�che�l O S� 1999)
Re: date pref (M�che�l O S� 1999)
Re: date pref (M�che�l O S� 1999)
Re: date pref (M�che�l O S� 1999)
Re: date pref (Kenneth Grome 1999)
Re: date pref (Christer Olsson 1999)
date pref (M�che�l O S� 1999)
RE:math context ignores date prefs? (John Hill 1998)
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.>>>>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?:-))M#237#che#225#l, let's assume your db is named xxx.db ... and that the fieldDate field is the one that's currently storing your dates in your dd/mm/yyyy format ... and you have a sku field in that db with a unique value in it for each record in the db. This is how I would do it:1- Quit webcat.2- Make a copy of your db for backup, just in case ...3- Change your DateFormat pref to %m/%d/%Y via BBEdit.4- Change your ReadDateFormat pref to mdy via BBEdit.5- Launch webcat.6- Run this webdna code ONLY ONCE:[search db=xxx.db&neskudatarq=[blank]][founditems][replace db=xxx.db&eqskudatarq=[sku]]fieldDate=[math]{[getchars start=4&end=6][fieldDate][/getchars][getchars start=1&end=3][fieldDate][/getchars][getchars start=7&end=10][fieldDate][/getchars]}[/math][/replace][/founditems][/search]Sincerely,Kenneth GromeWebDNA Consultant Kenneth Grome

DOWNLOAD WEBDNA NOW!

Re: date pref

1999

Top Articles:

Related Readings: