I have been using a plugin in my Moodle instance for some time called Course Recompletion. Our company has a number of annual training courses, and the plugin works great when resetting these courses every 365 days after a user has completed the course.
In the database, via SQL, I am trying to determine how long it takes for a user to complete a course after it has been reset. I am calling this column "Date Differential." The SQL script I am writing is on the plugin Configurable Reports.
The problem I am having is that the Course Recompletion plugin table does not track new enroll time after a course has been reset. I have been unsuccessful in trying to calculate this date. The original enrollment date is recorded within the Moodle database, but the most recent enroll time (upon course reset) is not.
Is it maybe possible to calculate a course MAX completion date and then add 365 days? If this were possible then I could refer to that calculation as the most recent enrollment time. My knowledge of SQL is a bit limited, but I have been trying to learn as much as I can.
If anyone has any suggestions as to how I would calculate a user's enroll time after a course has been completed and reset then that would really help me out. Any advice or suggestions would be very much appreciated. Thanks to all the help I get in this community.