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]HTHAlexAlex J McCombie New World MediaChief Information Officer Drawer 607800/724.8973 Fair Haven, NY 13064Alex@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:
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]HTHAlexAlex J McCombie New World MediaChief Information Officer Drawer 607800/724.8973 Fair Haven, NY 13064Alex@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)