Avatar

Level 2

Hi @Yamila1981 ,

You can make a query activity on xtk:workflow table which fetches workflows on basis of their last execution using date-time function "DaysAgo(5)". Now the DaysAgo() function returns the date and current time so you can wrap this function under DateOnly so the start time is 00:00.
Here is an query condition example you may use on your side to achieve this where this query will return all workflows that were processed on or after 00:00 5 days ago to 23:59. :slightly_smiling_face: 

_Shubham_Goyal__0-1661239823184.png

 

 
Cheers,

Shubham