i've enabled completion tracking on my Moodle System. I've created an course with 5 activities, activitaed activity completion, enther the completion tracking setting after and set in the Block "Activities completed" the Aggregation method to "all", and set a check in each activity checkbox. If i finish all activities as a student, the course should be marked as completed. but i can't find an "completion date" for this course in the database tables. i've looked in mdl_course_completions , mdl_course_completion_crit_compl but everywhere i get a null in the timeend column.
How can i retrieve, if a course is completed by a student and get the completion end date?