Below is the SOQL to query data which was modified between 1 PM and 5 PM.
Sample SOQL:
SELECT Id, LastModifiedDate FROM Account WHERE LastModifiedDate = TODAY AND HOUR_IN_DAY(LastModifiedDate) >= 13 AND HOUR_IN_DAY(LastModifiedDate) < 17
Tuesday, February 14, 2017
How to query data which was modified in specific time limit in Salesforce?
Below is the SOQL to query data which was modified between 1 PM and 5 PM.
Sample SOQL:
SELECT Id, LastModifiedDate FROM Account WHERE LastModifiedDate = TODAY AND HOUR_IN_DAY(LastModifiedDate) >= 13 AND HOUR_IN_DAY(LastModifiedDate) < 17
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment