function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

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

Data Loader Export - Date/Time field timezone

Does anyone know what time zone the date/time fields are when you export with the data loader? I have a file that shows 3/1/2012 but in sfa it's showing as 2/29/2012.  I thought it was cause of the leap year, but not all records with 2/29/2012 in sfa are showing as 3/1/2012 on the file.

SuperfellSuperfell

Typically datetimes returned from the API are in UTC, i don't think the data laoder converts then to the local timezone.
AmitSahuAmitSahu

This could be due to the fact that, your time zone on the system and timezone of the user you are using in the Dataloader and you ran the dataloader when the time at you end was about 23.59 .   Can you check if there is any time difference in sf and your system, when you are creating a record in SF ?
BewitchedBewitched

Hi,

 

Just tried doing this at my end and found that date is fine...but time is differrent...

This is what it shows in data Loader

2011-08-17 T21:24:00.000Z

 

where as in my org it shows as:-

8/17/2011 5:24 PM

 

Could be due to Time Zone Offset..

 

Thanks,

Tulika

 
AmitSahuAmitSahu
2011-08-17 T21:24:00.000Z

 

This is the format Dataloader keeps the datetime fields.. At least  for SOQL that uses this format. Yes that is the UTC time zone