• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 654
  • Last Modified:

Salesforce.com: LastModifiedDate vs. SystemModstamp

Hi All

According to SF's page on System Fields, SystemModstamp gets updated 'Date and time when this record was last modified by a user or by an automated process (such as a trigger). '.

Question:  Does anyone have a definitive list of 'or by an automated process'?

Reason I ask is because I have an SSIS package connecting to SalesForce.com where each Data Source has ... 'WHERE SystemModstamp > <@User::dt_last_success>', and I'm observing that I'm getting way more rows that are reflected in a day's data entry activity. I haven't proved this yet by doing a compare of rows across days, but that might be coming.

Thanks in advance. Jim
Jim Horn
Jim Horn
1 Solution
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
Answered here.  

Think of anything that happens by the system AFTER a user clicks save:

Workflow field updates
Rollup summaries causing triggers to fire
and possibly many other things.
So potentially the mod time can be > the success time if it happens slowly enough in SF to be > than the timestamp in the remote system.

And any of the above could result in changes in column values.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now