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
goabhigogoabhigo 

CreatedDate is wrong when uploaded via Data Loader

Hi,

I am encountering strange problem again. I have a csv file which has around 100 older leads, some of them are 2008,2009 also. When I upload through data loader the leads whose created date is less than 2011 is loaded perfectly, but 2011 leads are not. Those leads have strange created date values like - 11/7/2011 is loaded as 19/4/2011. The time zone setting in data loader, salesforce setup is correctly set.

 

Whats wrong?

knthornt1knthornt1

What is the format of the CreatedDate in your csv file. It should be yyyy-mm-ddThh:mm:ssZ
goabhigogoabhigo

Its

2011-7-11T15:58:25.000Z IST
MLamb2005MLamb2005

Try leading the 7 with a zero:

 

2011-07-11T15:58:25.000Z IST
goabhigogoabhigo

Found out one more thing. When I upload, the dates are proper, but when my colleague loads the same data its wrong!!!

Wondering how it is possible, completely illogical. The time zone setting in both data loader and SFDC is similar. Also system date,time is correct. Totally speechless........