Re: Silly date question

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 68168
interpreted = N
texte = Steve Craig wrote: > Hi > > Sorry but it's late in the day! > > I have a variable [StartDate] which stores a date value in dd/mm/yyyy > format. On occasion it could be d/mm/yyyy or dd/m/yyyy, is there a way > I can format it to always be dd/mm/yyyy ie never 3/4/2006 always > 03/04/2006. > > I know it should be stored as a number but unfortunately I have to work > with what I have. > > Thanks for any help. http://webdna.smithmicro.com/ref/pages.html?context=AllTags.html#Date If you want to *change* currrently stored values.. then you will have to do a replace: [!]## finds all records and replaces the startdate value with a new formated start date value - untested [/!] [replace db=yourdb&nedatarq=find_all]StartDate=[url][format Days_To_Date %d/%m/Y][math]{[StartDate]}[/math][/format][/url][/replace] ....should do it. Donovan P.S. - watch my email line breaks and replace "" of course. -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Desktop Publishing, Print Consulting, Labels -> <-Glass Products, off-hand Classes/studio rental-> PH:> (608) 835-2476 | Forum:> http://egg.bz/forum/ Web Sites:> http://www.euca.us & http://www.egg.bz =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Silly date question ( Donovan Brooke 2006)
  2. Re: Silly date question ( Donovan Brooke 2006)
  3. Re: Silly date question ( Steve Craig 2006)
  4. Re: Silly date question ( Steve Craig 2006)
  5. Re: Silly date question ( Donovan Brooke 2006)
  6. Re: Silly date question ( Gary Krockover 2006)
  7. Re: Silly date question ( Donovan Brooke 2006)
  8. Silly date question ( Steve Craig 2006)
Steve Craig wrote: > Hi > > Sorry but it's late in the day! > > I have a variable [StartDate] which stores a date value in dd/mm/yyyy > format. On occasion it could be d/mm/yyyy or dd/m/yyyy, is there a way > I can format it to always be dd/mm/yyyy ie never 3/4/2006 always > 03/04/2006. > > I know it should be stored as a number but unfortunately I have to work > with what I have. > > Thanks for any help. http://webdna.smithmicro.com/ref/pages.html?context=AllTags.html#Date If you want to *change* currrently stored values.. then you will have to do a replace: [!]## finds all records and replaces the startdate value with a new formated start date value - untested [/!] [replace db=yourdb&nedatarq=find_all]StartDate=[url][format Days_To_Date %d/%m/Y][math]{[StartDate]}[/math][/format][/url][/replace] ....should do it. Donovan P.S. - watch my email line breaks and replace "" of course. -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Desktop Publishing, Print Consulting, Labels -> <-Glass Products, off-hand Classes/studio rental-> PH:> (608) 835-2476 | Forum:> http://egg.bz/forum/ Web Sites:> http://www.euca.us & http://www.egg.bz =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Donovan Brooke

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:

Disappearing data (2002) Snake Bites (1997) mySQL or MS SQL (2000) [OT] Google Codesearch (2006) Online reference (1997) RE: Redirect (1998) Searching Multiple DBs (1997) Checking for WebCatalog Version (2000) SMSI FTP - calander system (2002) virtual virtual hosted store.... (1998) purchase.log file (1997) autosensing lanague selection (1997) [OT] Yahoo! Front Page (2002) Stinkin' [Referrer] (1998) RE: [WebDNA] WSDL Wizzard (2009) Lineitems [text*] (2004) Smith Micro supports our users in so many ways... We are here to (1999) notification solutions (1997) WC2b15 File Corruption (1997) Return records from another (1997)