Time issue - Export CSV

Hi Saeed,

Exported data uses an ISO 8601 format for the timestamp which is timezone-aware but it is displaying in UTC time zone and not in the appliance's time zone.

A workaround is:

To import the CSV file into Excel instead of just opening it (Open Excel > Select the Data tab, in the Get & Transform Data group, click From Text/CSV,
- See this link for more details: https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba
- This will properly parse the ISO 8601 format and display it according to the locale of the user.

Thanks!

Hi Saeed,

Exported data uses an ISO 8601 format for the timestamp which is timezone-aware but it is displaying in UTC time zone and not in the appliance's time zone.

A workaround is:

To import the CSV file into Excel instead of just opening it (Open Excel > Select the Data tab, in the Get & Transform Data group, click From Text/CSV,
- See this link for more details: https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba
- This will properly parse the ISO 8601 format and display it according to the locale of the user.

Thanks!