Apex Code Development You need to sign in to do that
Don't have an account?
srikanth 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
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
Please take a look on the below post, it will be helpful to you..!
http://salesforcekings.blogspot.in/2013/11/data-loader-tips-and-tricks_21.html
Thanks