Matt Palmer ☁️’s Post

View profile for Matt Palmer ☁️, graphic

Director, Client Services @ Enrollment Rx | MBA, CRM, Salesforce Expert

Salesforce Tip: SystemModStamp vs LastModifiedDate What is the difference between these 2 system date values on a record and why does it matter? 1. Last Modified reflects a change by a user on a record in Salesforce but is not an indexed field. 2. SystemModStamp reflects that change as well but is an indexed field and will also reflect record changes related to: a. The archive date is extended by more than 365 days. b. An existing picklist value is updated and not replaced with an existing picklist value. c. A Contact's e-mail address is flagged, as per the 'Email Bounce Management' configuration. d. The 'LastActivityDate' field is modified. e. A Roll-up summary field is created, which will update all the parent records' 'SystemModstamp' asynchronously. Why does this matter? Well when building a SOQL query it is important to note that these 2 date fields can have differing values, and an indexed field is important when dealing with large data volumes. This here is a great guide breaking down developer considerations when using the 2 fields: https://lnkd.in/eGM2c2hF #salesforce #developer #awesomeadmin

Prabhu Mohan

Lead Salesforce Developer | 4x Salesforce Certified | 2x Copado Certified | 2x Flosum Certified | 1x Trailhead Ranger

1mo

Insightful and exciting to explore.

To view or add a comment, sign in

Explore topics