+ Start a Discussion
srikanth bellamkondasrikanth bellamkonda 

How do I upload date format as I expected using data loader

Actually data loader is loading wrong dates into SFDC Org.
please observe this,

CASE:1 (Correctly Loaded)
Actuall datetime value : = 12/7/11 11:36 PM (MM/DD/YY)
converted datetime value with time zone := 2011-12-07T23:36:44.44Z (yyyy-mm-ddThh:mm:ss.sssZ)
 Result in SFDC: = 7/12/2011 7:36 PM (Correctly loaded DD/MM/YYYY)

where as in 

CASE 2: (Wrongly loaded)
Actuall datetime value : = 4/13/12 9:32 AM (MM/DD/YY)
converted datetime value with time zone := 2012-04-13T09:32:01.01Z (yyyy-mm-ddThh:mm:ss.sssZ)
 Result in SFDC: = 1/4/1913 4:32 AM (Wrongly loaded DD/MM/YYYY)

I found that,
1. The MONTH with single DIGIT are loaded Wrongly. (CASE: 2)
2. The MONTH with double DIGIT are loaded Correctly (CASE: 1).

Timezone is (GMT-04:00) Eastern Daylight Time (America/New_York).
Please provide solution on this.
Thank you

Arunkumar RArunkumar R
Hi Srikanth,

Please take a look on the below post, it will be helpful to you..!

Akshay DeshmukhAkshay Deshmukh
In Data Loader settings. uncheck checkbox "Use European Date Format". and try.