Re: Formatting dates stored in db

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49275
interpreted = N
texte = On 4/7/03 3:57 PM, WJ Starck wrote:> What's the best way to convert from my format (YYYYMMDD) to MM/DD/YYYY? Don't know if its the best way, but it will work.[text]monthvar=[getchars start=5&end=6][thedatefield][/getchars][/text] [text]dayvar=[getchars start=7&end=8][thedatefield][/getchars][/text] [text]yearvar=[getchars start=1&end=4][thedatefield][/getchars][/text] [text]newdate=[monthvar]/[dayvar]/[yearvar][/text]HTH AlexAlex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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: Problem with formatting dates stored in db ( "Jesse Crofoot" 2003)
  2. Re: Problem with formatting dates stored in db ( Jay Van Vark 2003)
  3. Problem with formatting dates stored in db ( "Jesse Crofoot" 2003)
  4. Re: Formatting dates stored in db (Velma Kahn 2003)
  5. Re: Formatting dates stored in db (Rob 2003)
  6. Re: Formatting dates stored in db (WJ Starck 2003)
  7. Re: Formatting dates stored in db (WJ Starck 2003)
  8. Re: Formatting dates stored in db (Rob 2003)
  9. Re: Formatting dates stored in db (WJ Starck 2003)
  10. Re: Formatting dates stored in db (Matthew A Perosi 2003)
  11. Re: Formatting dates stored in db (Alex McCombie 2003)
  12. Re: Formatting dates stored in db (WJ Starck 2003)
  13. Re: Formatting dates stored in db (WJ Starck 2003)
  14. Re: Formatting dates stored in db (Donovan 2003)
  15. Re: Formatting dates stored in db (Alex McCombie 2003)
  16. Re: Formatting dates stored in db (Donovan 2003)
  17. Re: Formatting dates stored in db (WJ Starck 2003)
  18. Formatting dates stored in db (WJ Starck 2003)
On 4/7/03 3:57 PM, WJ Starck wrote:> What's the best way to convert from my format (YYYYMMDD) to MM/DD/YYYY? Don't know if its the best way, but it will work.[text]monthvar=[getchars start=5&end=6][thedatefield][/getchars][/text] [text]dayvar=[getchars start=7&end=8][thedatefield][/getchars][/text] [text]yearvar=[getchars start=1&end=4][thedatefield][/getchars][/text] [text]newdate=[monthvar]/[dayvar]/[yearvar][/text]HTH AlexAlex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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/ Alex McCombie

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:

Uploading a new database (2001) WebCommerce: Folder organization ? (1997) Stinkin' [Referrer] (1998) For those of you not on the WebCatalog Beta... (1997) Is this possible, WebCat2.0 and checkboxes (1997) Review comparison by PC Magazine: Open for On-line Business (1997) WebCatalog Q & A pages (1997) Showif -what am I missing??? (1999) Obtaining a dice result (2007) What port is Email on ? (2000) WebCat b13 CGI -shownext- (1997) [accountNum] and [math] (1997) Strange intermittent WebDNA problems (2008) Summing fields (1997) Nesting [RAW] (1998) requiring form fields? (2000) This may make you do a double take (2004) Dark Horse Comics success story (1997) Searching for all records (1998) WebCatalog on G3 Macs? (1997)