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 settings as of the date the record was added.
If you want all previous records to reflect the latest settings then you will need to export, void and re-import your learning records.
Step-by-step guide
To update existing records:
- 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 column 1, change Username to actor
- 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
Related articles