Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
eileen103eileen103 

Time Zone Issues Using Data Loader

Hello:

 

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?

 

Thanks,

Eileen

 

NasipuriNasipuri

Hi, 

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 Salesforce.com org . After this start your data loader and load the data. 

 

Thanks and Regards,

Dinesh Nasipuri

Dinesh.Nasipuri@gmail.com

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

Hi Dinesh:

 

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

 

Thanks,

Eileen
ColinKenworthy1ColinKenworthy1
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).