How to query data which was modified in specific time limit in Salesforce?

Below is the SOQL to query data which was modified between 4 PM and 6 PM.

Sample SOQL:

SELECT Id, LastModifiedDate FROM Account WHERE LastModifiedDate = TODAY AND HOUR_IN_DAY(LastModifiedDate) >= 16 AND HOUR_IN_DAY(LastModifiedDate) < 18

Cheers!!!

No comments:

Post a Comment