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
david.sdavid.s 

Loading Date and Date/Time Format using Data Loader.

    We have requirement for a custom field MS Created Date having data type as date/Time. I loaded the field using data loader. But the date is getting loaded correctly but the time is not get loaded properly.
 For eg. If i load date/ time through dataloader as 04/10/2006 09:40:40:000 (dd/mm/yyyy hh:mm:ss:SSS format ), but in the sfdc it is getting loaded as
04/10/2006 06:10(dd/mm/yyyy hh:mm:ss:SSS format) so there is a 3 hour 30 minute difference is there.
Using data loader i used the format as yyyy-MM-dd'T'HH:mm:ss.SSS'Z' format.
I tried all the format which are given in the dataloader document as shown below.
•yyyy-MM-dd'T'HH:mm:ss.SSS Pacific Standard Time
• yyyy-MM-dd'T'HH:mm:ss.SSSPacific Standard Time
• yyyy-MM-dd'T'HH:mm:ss.SSS PST
• yyyy-MM-dd'T'HH:mm:ss.SSSPST
• yyyy-MM-dd'T'HH:mm:ss.SSS GMT-08:00
• yyyy-MM-dd'T'HH:mm:ss.SSSGMT-08:00
• yyyy-MM-dd'T'HH:mm:ss.SSS -800
• yyyy-MM-dd'T'HH:mm:ss.SSS-800
• yyyy-MM-dd'T'HH:mm:ss
• yyyy-MM-dd HH:mm:ss
• yyyyMMdd'T'HH:mm:ss

But also I am getting the same incorrect value with no change in the time.
I am using the Time Zone as "GMT+01:00) Central European Time (Europe/Paris)"
in SFDC and my computer time zone is GMT +5:30.
Please help me to resolve the problem.
Thanks in advance for your solution.




BabugarhBabugarh
yyyy-MM-dd'T'HH:mm:ss.SSS GMT+01:00  should solve the problem...It did to me!