Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Date Field Formatting in Report Exports

Avatar

Level 2
Hi there - I'm trying to do an hours report for all of November and December (i.e. a LOT of data), including the date of hour entry. However, every time I export to excel (we need to keep a local copy), the date field turns into a series of numbers instead of a date (e.g. 43770 equates to November 1). Has anyone else experienced this? Excel export: Workfront report (works correctly): Laura O'Malley Operations Manager precisioneffect Boston, MA
1 Reply

Avatar

Level 2
Hi Laura I think that is just Excel – it stores dates and times in a number format, where the part after the decimal point represents the time. If you convert the column in Excel to Date format the expected date should appear and be retained Hope that helps Regards Bob