Re: Converting Dates to Mathematica Format

*To*: mathgroup at smc.vnet.net*Subject*: [mg52096] Re: Converting Dates to Mathematica Format*From*: Bill Rowe <readnewsciv at earthlink.net>*Date*: Wed, 10 Nov 2004 04:46:01 -0500 (EST)*Sender*: owner-wri-mathgroup at wolfram.com

On 11/9/04 at 1:37 AM, gregory.lypny at videotron.ca (Gregory Lypny) wrote: >Is there a simple way to convert dates imported as "Day/Month/Year" >to the Mathematica format of {Year, Month, Day}? My dates are one >column in a matrix of data. Mathematica appears to be treating >them as strings. I used StringReplace to turn 15/10/2004 to >15,10,2004 but it remains a string, of course. >Any suggestions would be most appreciated. My alternative is to >import all of the dates as 20041510 so the ordinal ranking is >maintained by date calculations would not be possible. The following will do what you want FromDate[Flatten[ {Reverse@ToExpression[ "{"<>StringReplace["15/10/2004",{"/" -> ","}]<>"}" ], 0, 0, 0}]] 3306787200 ToDate[%] {2004, 10, 15, 0, 0, 0.} I'll leave it to you to decide whether this method should be called simple or not. -- To reply via email subtract one hundred and four