function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
avkavk 

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)

Best Answer chosen by Admin (Salesforce Developers) 
dnvansantdnvansant

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

dnvansantdnvansant

Try MM-DD-YYYY
avkavk

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....
dnvansantdnvansant

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 .. 

This was selected as the best answer
avkavk

Yeah..! ur right.. I got it.. Thanks.. So ideally the format should be MM/DD/YYYY only always....