6

How to define the "where clause" in SFDC SOQL to extract the date that have been modified in last 24 hours. Thanks.

PS : I am using the QUERY rest URI for query the data.

16

You can use the existing LastModifiedDate or SystemModStamp fields in your SOQL query (See System Fields). The LAST_N_DAYS or TODAY date literals may be useful. Otherwise you can use a specific calculated UTC Date time value.

Select Id from Account where SystemModStamp >= LAST_N_DAYS:1
Select Id from Account where SystemModStamp >= 2014-11-19T23:01:01Z

There was a recent blog post on the performance implications of LastModifiedDate vs SystemModStamp - Force.com SOQL Performance Tips: LastModifiedDate vs SystemModStamp

4
  • Thanks it's working fine.. what's the difference between systemModStamp and lastmodifiedDate. – amidstCloud Nov 20 '14 at 20:48
  • @AnkitKhandelwal The differences are covered in the linked System Fields and Performance Tips pages. SystemModstamp gets updated for all changes and is strictly read-only. LastModifiedDate is only for user changes and can be updated. – Daniel Ballinger Nov 20 '14 at 21:28
  • Below query won't give last 24 hours data , if I don't run it @ 12 in Midnight.. I have a java program that schedule @ 8 pm ever ngiht and I have get the data for last 24 hours. /services/data/v32.0/query/?q=select ID from Custom_Object_HDS__c where LastModifiedDate = Today – amidstCloud Nov 21 '14 at 1:05
  • @AnkitKhandelwal look at the definitions of the Date Time literals. They are defined along the lines of "Starts 12:00:00 of the current day and continues for 24 hours". You will need to manually calculate the required UTC date literal as per the second example query. – Daniel Ballinger Nov 21 '14 at 1:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.