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/time not loaded exactly

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...

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.
Not yet,but still trying it.
When we load the Records are getting updated Randomly
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.

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