function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

CreatedDate is wrong when uploaded via Data Loader


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?


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



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


Try leading the 7 with a zero:


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


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