I have an Excel file with dates that I want to upload to a table. The date format in Excel is yyyy-MM-dd. After auto-mapping all fields I followed this instruction to update the field map for the date field.
It was yyyy-MM-dd HH:mm:ss but I changed it to yyyy-MM-dd.
After I run the transform, all fields map correctly except for the date fields. The error says that the format is still yyyy-MM-dd HH:mm:ss!
I have tried this multiple times now but I always get the same error. Any help appreciated.
