function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Rishabh Patel 1Rishabh Patel 1 

SOQL lastmodified date time within 60 minutes

How do I Write a SOQL query which selects all leads that are modified within 60 minutes from now 

Select all  the lead Lastmodified date within 60 minutes or last hour 

Raj VakatiRaj Vakati

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 Lead WHERE Minutes_Since_Modified__c <= 60

OR 
  
Datetime hourBack = Datetime.now().addMinutes(-60);
List<Lead> records = [
    SELECT Name FROM Lead
    WHERE LastModifiedDate >= :hourBack
];