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:
3 card formulas! (1999)
&FieldNametype=time unnecessary? (2000)
switching users (1998)
Re:Signal Raised (1997)
How to sell events to customer and his guests?? (2005)
BBedit wierdness upon opening "wide" database (2006)
View order not right (1997)
Add message to Order (1997)
[/application] error? (1997)
[WebDNA] writefile (2009)
WebCat2.0 [format thousands .0f] no go (1997)
Data Entry ... Excel Style ... How To? (2001)
Pull Down Search (2000)
RE: E-mail formating queston (1999)
Extended [ConvertChars] (1997)
More on the email templates (1997)
New Mac Public Beta Available (1997)
Design Help Needed (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
WebCat2 - storing unformatted date data? (1997)