SOQL can be used find the last data entry date on Standard and Custom object in Salesforce.
Sample SOQL:
SELECT Id, CreatedDate
FROM Account
WHERE CreatedDate = LAST_N_DAYS:5
ORDER BY CreatedDate DESC
LIMIT 1
Adjust the CreatedDate filter if there is no result.
Output:
Note:
Timing in GMT/UTC.