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
If your Report Excel Export Format user preference is set to .csv, when you export reports that include date values, those values will be treated as strings, 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). To do this: