Remind learners 7 days before an instructor-led offering is starting (Alerts Composer)

Content

Hi all,

we are trying to create an Alert which reminds Learners 7 days before an activity of an offering, they are enrolled, for starts.

There fore we created the following Alert:

Ressource	learnerLearningRecords/selectedCourseOfferings
Expressions	${assignmentSubStatus} = 'ORA_ASSN_REC_NOTSTARTED'
	${offeringDeliveryMode} = 'ORA_ILT'
Ressource 2	learnerLearningRecords/selectedCourseOfferings/completionDetails
	${activityDate} = sysdate+7

If we replace the second ressource by ${activityDate} = sysdate>=7 & ${activityDate} = sysdate<=8 in result the mail is sent to every Learner who is enrolled for an offering in the future but not only in the next 7 days.

 

Does anyone know how to manage Alerts-Reminder only for activities in the next 7 days.