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:

Emailer 1.01 bombs (1997) Extended [ConvertChars] (1997) Checkboxes (1998) QuitFeedback & DBNotOpened errors (1997) problems with WebCat-Plugin (1997) boldwords (2001) Trouble with formula.db (1997) Error, 101 a DNS problem ? (1997) New York City sales tax database needed (1997) authenticating a second user (1997) FREE Web Server Monitor FREE (1997) Help! WebCat2 bug (1997) RE: WebCatalog NT beta 18 now available (1997) [WebDNA] Parsing XML...again... (2010) Generating unique SKU from [cart] (1997) shipCost not working v2.1b4 (1997) : fyi: getting ODBC MySQL ready for WebCat (2001) PCS Frames (1997) Webstar 1.3.1 PPC (1997) Looking up two prices in database? (1997)