You need to sign in to do that
Don't have an account?
johnc82
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.
Typically datetimes returned from the API are in UTC, i don't think the data laoder converts then to the local timezone.
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 ?
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
where as in my org it shows as:-
8/17/2011 5:24 PM
Could be due to Time Zone Offset..
Thanks,
Tulika
This is the format Dataloader keeps the datetime fields.. At least for SOQL that uses this format. Yes that is the UTC time zone