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 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.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 Grome WebDNA 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:

Electronic delivery (2006) Summary search -- speed (1997) Thanks Grant (1997) Passing Variables.. yikes, I'm dumb (2000) [accountNum] and [math] (1997) Initiating NewCart (1997) Extra carriage returns (1999) Email template names (1997) dollar $ signs in database (2000) send mail problem? (1997) Cut off from the list and can't get an answer to the confused re:QTY price updating question (1998) Multi-processor Mac info ... (1997) two unique banners on one page (1997) webcat license???? (1997) Plugin or CGI or both (1997) A new perspective ... (2005) Install problems on 3.08 (2000) Re:Running 2 two WebCatalog.acgi's (1996) Leap Day Triggers? -confirmation- (2000) Limitations on fields? Server is crashing (1997)