+ Start a Discussion
kkaalkkaal 

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?

 

Thanks 

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

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? 

Nick1746323Nick1746323
GMT+1 with DLS off is not GMT  =)
kkaalkkaal

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);

"25.09.2002"

"12.08.2004 16:57:21"

 

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

  "2002-09-24T23:00:00.000Z"

"2004-08-12T15:57:21.000Z"

 

That is strange!? 

Nick1746323Nick1746323

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 =(

 

 

kkaalkkaal

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!  

Nick1746323Nick1746323
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