List Info

Thread: problem with dates in csv reports




problem with dates in csv reports
country flaguser name
United States
2007-09-08 12:27:24
When I download a trac report in csv format, the dates for
creation
time and modified fields comeout as serial numbers, however
Ecel is
not able to interpret/convert these numbers into date
format, can
someone suggest a workaround so csv download these fiels in
the date
format like mm/dd/yy

thanks,
satyendra


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: problem with dates in csv reports
user name
2007-09-08 12:29:35
On 9/8/07, satyendra < sdhingragmail.com">sdhingragmail.com> wrote:

When I download a trac report in csv format, the dates for creation
time and modified fields comeout as serial numbers, however Ecel is
not able to interpret/convert these numbers into date format, can
someone suggest a workaround so csv download these fiels in the date
format like mm/dd/yy
 
I haven't looked myself, but when you say "serial numbers&quot; do you mean seconds since epoch? If so, a little Google-Fu revealed http://exceltips.vitalnews.com/Pages/T0096_Converting_UNIX_DateTime_Stamps.html ;
 
 - Aaron
&nbsp;

&nbsp;

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users"; group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to trac-users-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )