You need to sign in to do that
Don't have an account?

Major issue with date field in Apex Data loader
If DD/MM/YYYY is the date format in the csv file, then the date loaded in salesforce is unbelievably different…!
Ex: 26/10/2011 is the date in my csv file and the date is loaded in salesforce as- 2/10/2013 ..
what makes such a huge difference???
Is it like csv file doesn’t support this date format?
somebody pls respond..
I've tried all versions of data loader between 19 and 22.
Regards,
Anil
(anilcvm@yahoo.in)
If you look at the two dates. You'll notice that SF reads 26/10/2011 as the 26 month of 2011 which would be February 2013. That's where the 2/10/13 comes from.
Ex: 26/10/2011 loaded in salesforce as- 2/10/2013 ..
All Answers
Try MM-DD-YYYY
Yes.. I know it will work with MM/DD/YYYY, but I would like to know why it doesn't work with DD/MM/YYYY and why there is a big difference in the date value as I mentioned..
Thanks for the response....
If you look at the two dates. You'll notice that SF reads 26/10/2011 as the 26 month of 2011 which would be February 2013. That's where the 2/10/13 comes from.
Ex: 26/10/2011 loaded in salesforce as- 2/10/2013 ..
Yeah..! ur right.. I got it.. Thanks.. So ideally the format should be MM/DD/YYYY only always....