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

[AK73]

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.  

Thanks in advance!

[AK73]

@Viraj Hudlikar 

I used direct flow as well. Also applied same filter in list view with dates, it does fetch record.

Using above condition but not sure why count is 0 here.

[Viraj Hudlikar]

@AK73 - The screenshot, which is shared by you with red highlighted box, can you check what date is passed while lookup is running in runtime context and select same date when you do filter in list view. It will give you idea are you passing same filter or not. 

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[AK73]

Hi Viraj ,

I am using flow variable suggested by you. created 2 variable. Using below condition but it is fetching zero record and evaluation false hence not running further. Please see below screen and help. Also appreciate your help so far ! Thanks.

[Ankur Bawiskar]

@AK73 

somewhat complex to handle using flow.

Didn't you try to use scheduled job?

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

[AK73]

Not yet. Actually requirement is to from flow.