function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
AbAb 

dataloader.io error SOURCE: 'CloseDate' DESTINATION: 'CloseDate' is not a valid DATE.[Valid date format: MM/DD/YYYY (example: 02/20/1987)].

Hello,

I was trying to upload data in sandbox environment, 
I am getting error for close date but I have downloaded the data from production and i am surprised get this issue

error:
SOURCE: 'CloseDate' DESTINATION: 'CloseDate' is not a valid DATE.[Valid date format: MM/DD/YYYY (example: 02/20/1987)].

data actual
CloseDate
5/10/2052

​​​​​​​
Best Answer chosen by Ab
SwethaSwetha (Salesforce Developers) 
HI Sandrine,
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 settings as mentioned in https://salesforce.stackexchange.com/questions/102797/dataloader-fails-to-insert-data-due-to-different-date-format

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.

Also see https://help.salesforce.com/s/articleView?id=000385167&type=1


Worth noting that your locale settings determine the display formats for date and time, users’ names, addresses, and whether to use commas or periods in numbers. You need to prepare and edit the format of the Close Date in the CSV file to the format MM/DD/YYYY before import.


If this information helps, please mark the answer as best. Thank you