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

Time Zone Issues Using Data Loader



I am trying to update my new Entitlement fields with my old Entitlement fields data (date and time).

I was able to format the cells using the following yyyy-mm-ddThh:mm:ss.sssZ which changes the filed to the following format 2007-01-06T00:00:00.000Z and update the fields using Data Loader.

We use multiple time zones - the day on the field is correct, but it changed the time to GMT.

Does anyone know how to format the field so it shows the correct time?







For this close your Data Loader . Then set the system time (the computer from where you are running the data loader) zone to the time zone of your org . After this start your data loader and load the data. 


Thanks and Regards,

Dinesh Nasipuri

Message Edited by Nasipuri on 06-12-2009 02:00 PM

Hi Dinesh:


My computer and the sandbox are already both on the same time zone (EST). Any other suggestions?




I think the Z stands for Zero displacement from GMT. In your case you are about 8(?) hours behind so it should work if you replace the Z with -08:00 (or whatever the time difference really is).