I’m trying to import a CSV file with dates and times into a collection. In my CSV file, I’ve made the data in the datetime column match the format MM/DD/YYYY HH:mm. For example: 09/07/2020 14:00.
However, when I try importing this CSV file, and map the datetime column to the datetime column in my Wix collection, and select MM/DD/YYYY HH:mm as the “Date Format in File” for the datetime column, Wix imports the above date and time as 01/01/2020 13:00.
Am I missing something? How can I ensure that when importing, Wix will preserve the actual date and time from the data?