I am loading data from a CSV file to my salesforce org using Dataloader.io.
One of the fields for the record is a date field. In my salesforce org I have changed the time zone to (GMT+05:30) India Standard Time (Asia/Kolkata), my locale to English (India) for System Admin, Company Information and Personal Information.
So as expected the date formats are DD/MM/YYYY. In my CSV file, the date field has DD/MM/YYYY format as well.
However when I do an insert using Dataloader.io it throws an error saying
DESTINATION:
Date_Field__cis not a valid DATE.[VALID date format:
MM/DD/YYYY].
This single issue causes entire rows to fail. Any idea how I would solve this issue? Do I need to change anything in Dataloader.io?
Best Answer
Dataloader.io has an advanced settings pain on the run page of their wizard.
You can change the expected day-month order here.
Most Salesforce ETL tools have some setting like this.
If that doesn't fix it, then it is likely that something actually wrong with the date format itself, such as the delimiters between the different date elements not being acceptable, or other characters corrupting the date.
For reference here is the full settings pain: