Alert to be sent based on offering coordinator

Hi, our implementation is based on multi country where we have different Learn Admins for different countries. We have a requirement where the alert has to be sent out to Admins 7 days after the due date if the employee has not completed their required learnings within the Due Date. These Admins has to be country specific so, we have defined them as offering coordinators to identify them as country specific.

We tried the below in Filters but is not working.

Resource : learnerLearningRecords/selectedCourseOfferings. Match All

${offeringCoordinatorPersonNumber} = 'XXXXX'

${assignmentType} = 'ORA_REQUIRE_ASSIGNMENT'

${assignmentDueDate} > sysdate+6

${assignmentDueDate} < sysdate+8

${offeringDeliveryMode} = 'ORA_SP'

Has anybody achieved or worked on similar alert then any inputs around this would be helpful.