Re: Formatting dates stored in db
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49283
interpreted = N
texte = Still problems:[format days_to_date %a][math]{[getchars start=5&end=6][orderdate][/getchars]/[getchars start=7&end=8][orderdate][/getchars]/[getchars start=1&end=4][orderdate][/getchars]}[/math][/format]Gives me Friday for today and Wednesday for yesterday?Am I doing something wrong?--Will StarckNovaDerm Skincare Sciencehttp://www.novaderm.comwjs@novaderm.comOn Monday, April 7, 2003, at 04:00 PM, Donovan wrote:> WJ Starck wrote:>>> Ah, looks like I can do>>>> [format days_to_date %a]# of days since 00/00/0000[/format]>>>>> I see I can use [math] to convert a date to days since 00/00/0000.>>>> What's the best way to convert from my format (YYYYMMDD) to >> MM/DD/YYYY?>> I believe YYYYMMDD is a european format?? (some one correct me if I'm > wrong)> I don't know any other way to do this but text manipulation.>> [text]year=[getchars start=1&end=4][thedatefield][/getchars][/text]> [text]month=[getchars start=5&end=6][thedatefield][/getchars][/text]> [text]day=[getchars start=7][thedatefield][/getchars][/text]>> [text]newdate=[month]/[day]/[year][/text]> [text]dateasdays=[math][newdate][/math]>>> Donovan>>>>>>> -->>-------------------------------------------------------------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:
Still problems:[format days_to_date %a][math]{[getchars start=5&end=6][orderdate][/getchars]/[getchars start=7&end=8][orderdate][/getchars]/[getchars start=1&end=4][orderdate][/getchars]}[/math][/format]Gives me Friday for today and Wednesday for yesterday?Am I doing something wrong?--Will StarckNovaDerm Skincare Sciencehttp://www.novaderm.comwjs@novaderm.comOn Monday, April 7, 2003, at 04:00 PM, Donovan wrote:> WJ Starck wrote:>>> Ah, looks like I can do>>>> [format days_to_date %a]# of days since 00/00/0000[/format]>>>>> I see I can use [math] to convert a date to days since 00/00/0000.>>>> What's the best way to convert from my format (YYYYMMDD) to >> MM/DD/YYYY?>> I believe YYYYMMDD is a european format?? (some one correct me if I'm > wrong)> I don't know any other way to do this but text manipulation.>> [text]year=[getchars start=1&end=4][thedatefield][/getchars][/text]> [text]month=[getchars start=5&end=6][thedatefield][/getchars][/text]> [text]day=[getchars start=7][thedatefield][/getchars][/text]>> [text]newdate=[month]/[day]/[year][/text]> [text]dateasdays=[math][newdate][/math]>>> Donovan>>>>>>> -->>-------------------------------------------------------------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/
WJ Starck
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:
[ot] html question (2000)
When to Commitdatabase? (2004)
WebCat2 - [format thousands] (1997)
World Address Info (2003)
Robert Minor duplicate mail (1997)
Finding max value for a field (1997)
Apoligy (1997)
Fwd: Problem with order (1998)
ListWords passing multi values in one form field (2000)
[WebDNA] Talk archives (2010)
[OT] Missing access_log (2003)
Multiple SSL Keys (1998)
Getting total number of items ordered (1997)
New Web Site Developers Database (1996)
To Do list (2003)
sorry (1997)
emailer (1997)
Sendmail (SMTP) coming from smithmicro.com (2002)
Package Prices (2000)
RE: Re:Signal Raised (1997)