You need to sign in to do that
Don't have an account?
![Anja Botić Anja Botić](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
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](/forums/servlet/rtaImage?eid=9060G000000BdNL&feoid=Body&refid=0EM0G000000RbFH)
This is how the csv data looks like:
![User-added image](/forums/servlet/rtaImage?eid=9060G000000BdNL&feoid=Body&refid=0EM0G000000RbFM)
Suggestions?
This is how the csv data looks like:
Suggestions?
"Date Time" format in Data Loader.Please refer the below link.
- https://help.salesforce.com/articleView?id=Data-Loader-Import-data-for-Date-or-Date-Time-field-1327108684799&language=en_US&type=1
Hope it will be helpful.Best Regards
Rahul Kumar
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.