How to pull record from sysapproval_approver table which are older than 5 days but not older than 10

AK73
Tera Contributor

I need to pull record from sysapproval_approver table, which is older than 5 days but not older than 10 days and it is still in 'requested' state using lookup record. Below is the screen shot which I am using however it not giving desired result. Can some please help me to fetch record which falls between 5 to 10 days older from created date and not approved. I need to trigger reminder notification for these record to approver.  

AK73_0-1738341768586.png

 

Thanks in advance!

 

 

10 REPLIES 10

@AK73 

anyhow you are doing complex scripting in flow with flow variables etc

Not all requirements can be achieved using flow.

There are some situations which are complex and you need to use flow.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader