Universal date format for Excel interoperability

Posted over 1 year ago by Steve Spencer

Post a topic
Un Answered
Steve Spencer
Steve Spencer Admin

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. 

0 Votes


Login or Sign up to post a comment