If a learner still shows an old due date, a renewal window, or a "due soon" status after you changed the course's Expiration or recertification settings, the cause is usually an existing learning record that still has its original expiry date.
When a course's expiration settings are changed, 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 created. If you want all previous records to reflect the latest expiration rules, then you will need to somehow update the existing learning records.
Which Method to Use
The right method depends on how the course's learning records expire:
-
The course expires on a specific date (for example, December 31 for everyone). Every learner shares the same expiry date, so all existing records can be updated at once from the course's reset page, without a CSV file. Follow the procedure explained in Expiring Learning Records.
-
The course expires after a lapse of time (for example, one year after each learner completed it). Each learner has a different expiry date, so the existing records need to be updated using a CSV file. Follow the step-by-step guide below.
To learn more about the two expiration options, see Understanding Learning Record Expiration Options.
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
Important Notes
-
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.
Related Articles