Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2004
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2004

[Date Index] [Thread Index] [Author Index]

Search the Archive

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


  • Prev by Date: Re: Poles and Complex Factoring
  • Next by Date: nonlinear programming with differential-algebraic constraints (2)
  • Previous by thread: Re: Converting Dates to Mathematica Format
  • Next by thread: Re: Converting Dates to Mathematica Format