Return
-
Title
The format of date/time in exported Excel reports are not consistent -
Description
The format of date/time in exported Excel reports are not consistent. Sometimes it is a date string, other times it is a numeric date. This makes it very difficult to sort/filter by the column values.
Example:
-
Cause
This is an Excel issue.Excel uses the system's regional settings to determine and format the date/time values. By default TPAMs date format is Month/Day/Year. When the .CSV or .XLS file is opened on a system with an unexpected format (e.g Day/Month/Year), excel uses DD/MM/YYYY to read the date/time values resulting in a mismatch.
-
Resolution
WORKAROUND
Set the regional settings on the system to match the format of the exported CSV/XLS. For example :1. Navigate to Control Panel
2. Region and Languages
3. Update the format to English (United States)
TPAM date format can be set in /admin | System Status/Settings | System Date Format.