+ Start a Discussion
Anja BotićAnja Botić 

uploading csv with date

Uploading the data keeps failing because od the date. I've changed the dot to slash format and make sure to check the DD/MM/YYYY format in the Data Loader advanced options. 
User-added image
This is how the csv data looks like:
User-added image

Suggestions?
Rahul KumarRahul Kumar (Salesforce Developers) 
Hi Anja,

"Date Time" format in Data Loader.Please refer the below link. Hope it will be helpful.

Best Regards
Rahul Kumar
Anja BotićAnja Botić
Hi Rahul,

Thanx for the answer. I've tried with the yyyy-mm-dd format it dataloader.io and workbench, and it still failed. 
I think the problem is in the conversion from excel to csv, because the date changes to a 5-figure number, but I don't know how to prevent that.