When I try to insert some records, it throws back an Error report telling me that some of the records have a modified date before the created date. When I look at the corresponding field, this is not true and the modified date is indeed after the created date.

Why is this error being wrongly generated?

I'm using the Apex Data Loader.

  • Does the data you are loading include "Date Modified" and/or "Date Created"? – Keith C Apr 10 '14 at 16:02
  • Yes, of course. All of them do. The error is being generated off the checks on those two fields for each record. Salesforce has already turned on Audit Fields for the sake of migration for my company so that dates can be moved over. – Dezzie Apr 10 '14 at 16:07
  • Is it possible that the error is actually on one of the other records in the batch - that is, the error is reported on row x (1 of 200) but actually exists on row y? – cropredy Apr 10 '14 at 16:07
  • No, I've already pulled up a report of the situation from the old database and there is no record where the date created is after the date modified. – Dezzie Apr 10 '14 at 16:11
  • 1
    Have you checked the Date formats for dd:MM vs MM:dd mistakes? Check it against your organization date format – highfive Apr 10 '14 at 17:24

The Time Zone setting in the Apex Data Loader needed to be changed to GMT+00:00 since the time data is in GMT+00:00 format. It was set to GMT+04:00 and so was adding a four hours to the data I was migrating, making it seem like some of the recently created records were created in the future.

  • thanks for posting the answer; this is the kind of thing that would mess me up and leave me puzzled for some time – cropredy Apr 13 '14 at 19:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.