You need to sign in to do that
Don't have an account?
S 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.
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.
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
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