I have a CSV file with a date field stored as mm/dd/yyyy. When I import the file into my collection into a field defined as Date and Time, I get a yellow exclamation point indicating the CSV field did not match the data type and the CSV field is imported as Text.
This is not a code related issue and should not be asked in the Wix Corvid Forum.
For your answer you should be contacting Wix Support and reading their support pages about importing data.
https://support.wix.com/en/article/contacting-wix-support
You will find info about date and time fields here.
https://support.wix.com/en/article/importing-data-to-a-database-collection
I’ve tried uploading my reviews, using the EXAMPLE csv file, while only changing the MONTH, and saving it as a UTF8, but the dates under CREATED_AT always fail.
What’s going wrong?
use text format in csv and text should be like this yyyy-mm-dd
For checking this format just copy the date in your wix database and paste in notepad, you can easily understand the date format.
