Re: Conversion back to excel date format
- To: mathgroup at smc.vnet.net
- Subject: [mg73127] Re: [mg73104] Conversion back to excel date format
- From: Bob Hanlon <hanlonr at cox.net>
- Date: Sun, 4 Feb 2007 06:53:14 -0500 (EST)
- Reply-to: hanlonr at cox.net
{{a,b,c,d,e,f,g,{2004,11,15}}}/.
{y_,m_,d_}:>ToString[m]<>"/"<>ToString[d]<>"/"<>ToString[y]
{{a,b,c,d,e,f,g,11/15/2004}}
Bob Hanlon
---- Clifford Martin <camartin at snet.net> wrote:
> I have a list of numbers I've calculated. The last element in the list is a date in Mathematica format. I needed it to be in that format to use the Miscellaneous`Calendar functions. When I'm done I output the list (of lists) to a txt file and read it into Excel. (The guy I'm working with can only use Excel).
>
> So the list looks something like this for 1 row
>
> {{a,b,c,d,e,f,g,{2004,11,15}}} where a,b,c,d,e,f,g are numbers I've calculated. I'd like to convert the last element (the date) into a date format compatible with Excel such as 11/15/2004 before I export the data. Any suggestions?
>
> Thanks in advance.
>
> Cliff
>