Imagine you want to track when a specific record was last updated for reporting or auditing purposes, but you need that information in a custom field for easier access or filtering. Instead of relying solely on system notes, you can create a custom formula field to display the last modified date. This allows you to surface the latest update timestamp directly on the record, making it easier to monitor changes at a glance.
Navigate to Customization > List, Records, & Fields > [select field type] > New. In this example we will use transaction body field.
Name the field for example "Days from last modified"
Make sure that the stored value is unchecked
Enter this formula in the formula field:
FLOOR(TO_DATE({today}) - TO_DATE({lastmodifieddate}))
Click Save to apply changes. This can be applied to any records.