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

Data Loader: Date shifts by -1 day or -1 hr

I am located in Europe and we format our dates this way: dd.MM.yyyy HH:mm:ss


When I upload dates to SFDC, I get a dateshift by -1 day when I provide just the date. The date is ok when I provide date and time, but then I get a shift by -1hr.


Any thoughts what I am doing wrong?



Its a timezone issue. Try setting your system timezone to GMT.

No, sorry, that was not the cure. 

My system is set to GMT +1hr and DLS was configured. As we have already winter time, I unchecked the latter.

But still it does the timeshift.


Does the Data Loader have a build-in logic to compensate for the timezone? I checked the settings of the Data Loader, but it only lets me ajust for the European date and time format.


Could it be that the supplied java environment has to be configured? If so: how? 

GMT+1 with DLS off is not GMT  =)

Yep, I know what you mean. :-)


So I set my Windows time to GMT. My clock on the desktop reads one hr earlier than the actual time here.


Then I update with the Data Loader my datasets in SFDC with (copied from the source files);


"12.08.2004 16:57:21"


Then I export from SFDC the same data and read (again, copied from file) 




That is strange!? 


hi again,


its possible that you need to restart data loader after changing your windows timezone

if that doesn't fix it then I dont know =(




Yep :-) :-)


sorry that I forgot to restart the Data Loader...


But: What is now the conclusion? Do I allways have to switch my DateTime configuration when doing uploads to SFDC? I mean: that is not the local time for us!  

ah good. Yes unfortunately that is the case, if you are loading any date/time data. or perhaps the workaround is to format the dates to include timezone difference
Message Edited by Nick1746323 on 11-05-2009 04:29 PM