+ Start a Discussion
S PawarS Pawar 

Time value changed when inserting date time through dataloader.

Hi,

I am inserting some fields through data loader. Out of which date time field shows me a wrong value after insertion
eg: If i insert a date time field as 2014-04-04T17:04:00.00Z then it will shows me the correct date value but time value is inccorrect. 
Input Field inserted through dataloader = 2014-04-04T17:04:00.00Z
Output shown on browser( Saleforce UI ) = 4/4/2014 10:04 AM

Please assist me on this.
Ashish_SFDCAshish_SFDC
Hi ,


See the articles below, 


Why is the Data Loader importing dates incorrectly?

https://success.salesforce.com/answers?id=90630000000grvhAAA

Why do date fields import incorrectly when I use the Data Loader?

https://help.salesforce.com/HTViewHelpDoc?id=faq_import_general_wrong_date.htm&language=en_US

Salesforce: Data Loader Time Zone

http://simplysfdc.blogspot.in/2013/09/salesforce-data-loader-time-zone.html


Regards,
Ashish
Arunkumar.RArunkumar.R
Hi Pawar,

Please read the below link, it will surely help to you...!

http://salesforcekings.blogspot.in/2013/11/data-loader-tips-and-tricks_21.html

Thanks ...!
Arunkumar.R