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: [mg52099] Re: Converting Dates to Mathematica Format
  • From: bghiggins at ucdavis.edu (Brian Higgins)
  • Date: Wed, 10 Nov 2004 04:46:17 -0500 (EST)
  • References: <cmpq66$mot$1@smc.vnet.net>
  • Sender: owner-wri-mathgroup at wolfram.com

Greg, Will this work for you:

ls = {{23, 45, "15/10/2004"}, {13, 467, "23/07/1999"}, {78, 81, "03/02/2001"}}


Map[ToExpression[Read[StringToStream[#], {Word, Word, Word}, 
     WordSeparators -> {"/"}] /. {x_, y_, z_} -> 
     {z, y, x}] & ,ls[[All,3]]]

{{2004, 10, 15}, {1999, 7, 23}, {2001, 2, 3}}

Cheers,

Brian

Gregory Lypny <gregory.lypny at videotron.ca> wrote in message news:<cmpq66$mot$1 at smc.vnet.net>...
> Hello Everyone,
> 
> 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.
> 
> 	Greg


  • Prev by Date: Re: Adding text labels and such to 3D plots?
  • Next by Date: an [0,1] iterative based on the Farey tree that isn't b-normal
  • Previous by thread: Re: Converting Dates to Mathematica Format
  • Next by thread: BlockDiagonal