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!

[Viraj Hudlikar]

Hello @AK73 

In flow, I created 2 flow variables with date/time one as 5days ago date, 10days ago date.

Now I am setting value in this variable and once set using over lookup action with filter and once record is found you can send email as per your requirement.

Screenshot for your reference:

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]

As you mentioned, you created 3 variable. todays' date, 5days ago date, 10days ago date. I don`t see todays date anywhere. what is today's date variable use ?

[Viraj Hudlikar]

@AK73 - Sorry for inconvenience, earlier when I was replying here, I was considering today's date variable also but ended with two only. 

Note - I edited my actual answer. 😃

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.

[Viraj Hudlikar]

@AK73 
Rather than applying if loop why not use for each loop directly after lookup record if there is no record found it will not execute. Also, cross check in list view by applying same date and see if you are getting records?

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.