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:

Separate SSL Server (1997) Showif, Hideif reverse logic ? (1997) emailer setup (1997) cart number tracking (1998) returning the missing value (1997) Plugin or CGI or both (1997) Re:Call For Entry: Third Annual Business on The Internet (BOTI) Awards (1999) Document Contains No Data! (1997) showif with math? (2000) Error Lob.db records error message not name (1997) How to include weather (2000) [WebDNA] v7 success story (2012) RE: completed orders database (1997) [group] ? (1997) [FoundItems] solved - thanks (1997) WCf2 and nested tags (1997) Stop the madness. (1997) Protect Tag and Groups (1998) Large databases in WebCat (1997) RE: [isfolder] and [filename] (1997)