Fix faulty dates in CSV data exports
This can matter when importing data from a CSV into a website.
This issue presents itself as follows:
When viewing exported data from a Webbit such as a form, the store, or even user data, in Excel, some dates will be right-aligned and others will be left-aligned. Some are detected as dates in Excel, whilst the others are only seen as text.
The issue arises with data exported in US format (which is typical), and opened in Excel within NZ or Australia. Excel confuses the day value with the month and when the value is higher than 12, it no longer sees the data as a date.
This video demonstrates how to open the file in such a way that the data is correctly detected and displayed as dates in the local format. View the video full-screen for best results.
1557