Distinguishing issue dates from expiration dates

A common source of confusion in certification tracking is the mix‑up between when a card was issued and when it ceases to be valid. Professionals who rely on rosters for compliance need to know the difference, because renewal windows, grace periods, and liability windows all hinge on the correct date.

Issue date vs. expiration date – what each means

The issue date is the day the training was completed and the card was first issued. It marks the start of the validity period. The expiration date is the exact day the credential becomes invalid. Between those two dates the card is active; after the expiration date it is considered lapsed.

How to record them in a roster

Create two separate columns labeled Issue Date and Expiry Date. Populate each with the full YYYY‑MM‑DD format. If only one date appears on the physical card, note the missing field and calculate the other using the issuer’s standard validity period (e.g., “CPR valid 2 years from issue”), noting the assumption in the record.

Worked example

Kevin Tran’s food handler card lists an issue date of 2023‑09‑01 and an expiration date of 2025‑08‑31. The record shows “Expires in 7 days” because today’s date is 2025‑08‑24. By comparing the two columns, the reader can see the card has exactly four years of validity, and the upcoming expiry is correctly calculated. If the record had only stored the expiration date, the four‑year issuance history would be lost.

Reusable artifact

Sample row for a single credential | Employee | Card Type | Issue Date | Expiry Date | Days Until Expiry | |----------|-----------|------------|-------------|-------------------| | Kevin Tran | Food handler | 2023‑09‑01 | 2025‑08‑31 | 7 |

This format lets anyone scan the row and instantly see both the birth and death dates of the credential.

Exception

When a certificate is issued with a “rolling” validity (e.g., a safety permit renewed every 6 months on the anniversary of issue), record the issue date and then calculate each subsequent expiry by adding the interval to the original issue date. Do not shift the expiry forward based on renewal transactions; keep the original issue date as the anchor, and document the calculation in the record.

Related: Cert Expiry Tracker features.