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
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?