Skip to main content
All CollectionsSalesforce How-Tos and Best Practices
Tracking the Earliest Date of on when a Field was being Tracked in Field History Tracking
Tracking the Earliest Date of on when a Field was being Tracked in Field History Tracking
Engineering Swantide avatar
Written by Engineering Swantide
Updated over a year ago

To find out the Earliest Date when a Field was being tracked. Use the Inspector and SOQL to query against the [ObjectHistory] Object. While you could possibly do this in a report, your Org will may have many records (In this Example Leads) and therefore it will take some time to update the report to query.

Therefore, using the Lead Object as an Example, to find the earliest date when LeadSource was being tracked in the LeadHistory object, you would need to sort the results by the CreatedDate field in ascending order and then limit the results to 1 record.

Note: You would use the following SQL Query from a tool such as the DataLoader or the Inspector.

Here at Swantide, we recommend the Inspector.

SELECT Id, Field, CreatedDate FROM LeadHistory WHERE Field = 'LeadSource' ORDER BY CreatedDate ASC LIMIT 1

You can repeat this process for other Objects that allow for Field History Tracking.

Did this answer your question?