Skip to main content
New Idea

Filtering on Time of DateTime Field

Related products:None

We are looking to set-up rules that will run every 2 hours and would want to be able to filter on the time at which it was last modified/created. Is this something possible?

  • Since the rules will run every 2hours, we would like to filter Date >= Substract N hours from date
  • We are updating data in SF and it is increasing the number of records to update 

Thanks!

3 replies

phani_kumar
Forum|alt.badge.img+3
  • Gainsight Employee ⭐️⭐️
  • 332 replies
  • July 19, 2021

+1. Definitely a nice option to have in rules.

And should work like below scenario.

Date >= Subtract N Hours from Rule Date Hour.

 

So for ex, if the rule running on 17/12/2021 11 AM, then it will fetch the previous 2 Hours records on same date and again it is running on 1 PM then it should bring the previous 2 hours records,….and so on.

 

Thanks.


rakesh
Forum|alt.badge.img+1
  • Lets put your data to work!
  • 835 replies
  • July 30, 2021

This is a great idea. Thanks for posting this. I’ll add it to the backlog and we will evaluate this for our future development.


jordan_cook
Forum|alt.badge.img+2
  • Contributor ⭐️⭐️⭐️⭐️
  • 45 replies
  • April 28, 2022

This would be great to have. Right now, I have to go back a full day (up to 48 hours), just to catch records that were potentially modified in the past few hours.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings