How to fetch the records which has been modified in last 30 minutes without using apex?


1 Answer 1


The easiest way might be to make the following Minutes_Since_Modified__c formula:

(NOW() - LastModifiedDate) * 24 * 60

Then to query for it:

SELECT Id FROM Account WHERE Minutes_Since_Modified__c <= 30

Please refer to this Post for more info.

  • @StuartMittal Can you edit your question to provide more details about what context you will be using this soql in? I can't think of any soql I've used that I didn't use in apex (developer console queries aside). Mar 1, 2017 at 14:59
  • Please find my updated answer
    – Samir
    Mar 1, 2017 at 14:59

Not the answer you're looking for? Browse other questions tagged .