Alerts Composer: Reminder for Learners when an activity (offering) starts in the next 7 days

Content

Hello all,

we have the requirement to create a custom alert via Alerts Composer when an activity of an offering the Learner is enrolled to, is going to start in the next seven days:

We are struggeling with the filter criterias:

We used:

Resource: learnerLearningRecords/selectedCourseOfferings/completionDetails

trunc(${activityDate}) BETWEEN trunc(sysdate) AND trunc(sysdate+7) 

${activityStartTime} IS NOT NULL 

${activityStartTime} BETWEEN '00:00' AND '24:00'

 

but it doesn't work. 

In result we still receive mails like the attached one (Image 1) with "null" as the start time.

Otherwise we also get good mails (please see image 2)

The system seems not to take the activity date.