How do I make date field values in reports act like dates when exported to Excel?
Find resources designed to help you get the most from Replicon
In Web TimeSheet, if your Report Excel Export Format user preference is set to .csv, then all reports data that include Date values will be treated as strings, and not dates in Excel pivot tables. Therefore, you will not be able to group these values as you would be able to group dates.
To avoid this issue, set your Report Excel Export Format user preference to .xml (Excel XP or Greater).
Steps to set this up:
- Log in to Web TimeSheet and click the Settings link (located at the top, right-hand corner of the page)
- Change the Report Excel Export Format from .csv to .xml (Excel XP or Greater)
- Click Save.