Re: problem with dates in csv reports

satyendra

"Aaron D. Marasco" <Trac-MailRevRagnarok.com> wrote:

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" 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;

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---