It is on a custom object and until recently has been fine. I am loading an expiry date and my .csv file says 31/12/2015, however in Salesforce the date is loaded as 11/07/2017. I then updated a few records with the expiry date date of 30/12/2015 and the date in Salesforce was changed to 11/06/2017. The success files show the date I intended to load. I have also tried 2015/12/30 which returned 11/07/
as well.
I've looked at previous answers and it must be something to do with my settings as I have recently had a new laptop. Unfortunately I don't know what settings I should have!
Many thanks.
4 件の回答
Hi Sara,
Date format 'Data Loader' uses is set on your laptop. Go to 'Regional Settings' under 'Control Panel' ensure you select correct country/languge and alter date format as appropriate. This should be the first step before using data loader.If you look at the two dates. You'll notice that SF reads 31/12/2015 as the 31 month of 2015 which would be july 2017. That's where the 11/07/17 comes from.
Take a look here Salesforce: Data Loader Time Zone
Thanks,
Pritam Shekhawat
