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
iSfdciSfdc 

Data Loader date/time not loaded exactly

Hi,
When we try to Load,  Activity - Date/time field, we are not getting the exact date/time as in the Excel sheet.
We tried using the formats -  2006-9-19T0:00:00.000GMT+hh:mm, and found that out of 500 records 450 are loaded correctly ,the rest are lagging by 1 hour. They are all assigned to Users having same timezone. Is there Any problem in the batch size ?
Any  Solution/tips on this would help us...

Thanks
Gani
2006-9-19T0:00:00.000GMT+02:00
IntegrationsIntegrations
Did you ever get this figured out???  We are trying to load date/time into Activity Date Time using the same format that you mention in your post and we get the wrong date and time.  Niether match what we are trying to load from the spreadsheet.
iSfdciSfdc
Not yet,but still trying it.
When we load the Records are getting updated Randomly
 
Regards
Gani
CynicCynic
I am having similar joy with dates using the format yyyy-mm-dd, occasional entries off by a day although the csv is fine.
 
Solution is to specify time as well.
 
 2007-01-06T00:00:00.00Z.
 
 


Message Edited by Cynic on 03-07-2008 01:04 AM