When a course's expiration settings are changed in the course completion settings, it will only affect new learning records created going forward. Existing records will still show the expiration date as of the date the record was added. If you want all previous records to reflect the latest expiration conditions, then you will need to somehow update the existing learning records.
If you want to simply void all existing learning records for a single course, you should follow the procedure explained in Voiding All Learning Records in a Course. If you want to change everyone's expiration date for a single course to the same date, you should follow the procedure explained in Expiring Learning Records. If your scenario is more complex (e.g. multiple courses, selecting specific learning records, specifying different expiry dates for different people), you will need to follow the step-by-step instructions in this article.
Step-by-step Guide
To void or update existing learning records using a CSV approach:
- Export the records you want to change following this article: Exporting Learning Records
- Void the learning records, see Voiding Learning Records in this article: Importing Learning Records
- Prepare to import new Learning Records with an updated expires timestamp using the file exported in step 1
- In the expires column, update the date the record should expire. ex: Use Jan 1 when the course must be completed by Dec 31
- If the course expires by lapse time, you will need to calculate the new expires dates based on the timestamp column and set the cell format to YYYY-MM-DD. There are some formulas for convenience below.
- Import the new Learning Records: Importing Learning Records
Here are some formulas to calculate expiration by lapse time of 365 days. Cell K2 is assumed to be the timestamp cell.
Excel or LibreOffice
=DATE(LEFT(K2,4), MID(K2,6,2), MID(K2,9,2)) + 365
For more information, please see:
- Microsoft Excel cell formatting: Format cells
- LibreOffice cell formatting: Formatting data