Start a new topic

Universal date format for Excel interoperability

A client asked today how to create CSV files with dates that would open correctly in Excel regardless of the computer's locale settings.

(Remember that 07/12/2022 and 12/07/2022 are ambiguous).

The solution was to use the "reverse date format": 2022-12-07. Configure your date fields in Omniscope to use the yyyy-MM-dd format pattern (not perfect in terms of readability, but you might be able to live with this in your reports), and any CSV files you export will open in Excel correctly, regardless of locale. 

Login or Signup to post a comment