Apex Code Development You need to sign in to do that
Don't have an account?
Sandrine 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:
data actual
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
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