which filter to use in alert for activity start in x days

Hi all,

we have a learning alert which should be triggered for ILT and blended learning offerings when the first activity starts in exactly 7 days.

We tried different ressources and filter options but the alert is also sent for activities in the past. What needs to be changed so that the alert runs only for the activities which will take place in exactly seven days?

ressoures tested:

learnerLearningRecords/completionDetails

learnerLearningRecords/primarySelectedCourseOffering/completionDetails

expression tested:

${activityDate} <= sysdate + 7 AND ${activityDate} > sysdate + 6

${activityDate } > sysdate AND ${activityDate} < =sysdate+7

TRUNC(${activityDate}) >= ${AlertFilterUtils.addDays(AlertFilterUtils.getCurrentDate(), +6)} AND TRUNC(${activityDate}) <= ${AlertFilterUtils.addDays(AlertFilterUtils.getCurrentDate(), +7)}

Thanks for the support!