Re: date pref
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24034
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.Okay, let's assume you have an xxx.db file with a fieldDate field storing your dates in it in the standard mm/dd/yyyy format. Let's also assume you have a sku field in that db with a unique value in it for each record in the db. All you have to do is this:[search db=xxx.db&neskudatarq=[blank]][founditems][replace db=xxx.db&eqskudatarq=[sku]]fieldDate=[math]{[fieldDate]}[/math][/replace][/founditems][/search]... and you have to make sure you run this code ONLY ONCE -- or it will mess things up but good! Still, I woud make a copy of your database first, just in case either you or this webdna code screws up in some other way ... :)Sincerely,Kenneth GromeWebDNA 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.Okay, let's assume you have an xxx.db file with a fieldDate field storing your dates in it in the standard mm/dd/yyyy format. Let's also assume you have a sku field in that db with a unique value in it for each record in the db. All you have to do is this:[search db=xxx.db&neskudatarq=[blank]]
[founditems][replace db=xxx.db&eqskudatarq=[sku]]fieldDate=
[math]{[fieldDate]}[/math][/replace][/founditems][/search]... and you have to make sure you run this code ONLY ONCE -- or it will mess things up but good! Still, I woud make a copy of your database first, just in case either you or this webdna code screws up in some other way ... :)Sincerely,Kenneth GromeWebDNA Consultant
Kenneth Grome
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:
SSL and Webcat Authentication with IIS 5.0 on Win2K box (2000)
Some Advise needed (1997)
Location of Browser Info.txt file (1997)
Return records from another (1997)
Almost a there but..bye bye NetCloak (1997)
Faxing orders in place of email (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
Credit card processing - UK (1997)
Bulletin Board.... (2000)
WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997)
I need Typhoon Pro Tonight! (1999)
WebCat Bulletin Board Solution ? (1998)
Shopping cart not being assigned (1999)
Setting up shop (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
question: webmerchant connection (1997)
Can't ping (problem with [shell]) (2006)
RE: Explorer oddities (1997)
Sku numbers (1997)
A helpful tip to avoid pulling an Aaron OT (2000)