• Patrick Shea 25
  • NEWBIE
  • 0 Points
  • Member since 2020

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

I am following the code below to grab the records which has been modified within last 1 hour.

 

Select a.Id From Account a
Where a.LastModifiedDate = TODAY AND HOUR_IN_DAY(a.LastModifiedDate) > 24

 

But , I can't get any records.

Any idea to get something like this.