Description
Select the earlier supplied expiry or retest date for a lot label.
Supply-chain counts distinguish individual units, case packs, dispatches, receipts, in-transit stock and returns. A signed residual can expose an inconsistent record rather than prove physical loss. Costs, clearances and expiry/retest dates use separate conventions; accurate arithmetic does not replace stock inspection, material release or contractual review.
Select the earlier supplied expiry or retest date for a lot label.
When to use this tool
Use Lot Expiry Retest Earliest Label when you already have lotId, expiryDate, retestDate and need to select the earlier supplied expiry or retest date for a lot label.
How to use the tool and how it works
- Enter lotId, expiryDate, retestDate. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read earlierDate, label. Use the output convention below.
Require nonempty lotId and real YYYY-MM-DD dates at UTC midnight; choose expiry on equality, otherwise the earlier date, and format lot [date].1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| lotId | Lot Id | Required. Text; minimum UTF-16 length 1; maximum UTF-16 length 8192. |
| expiryDate | Expiry Date | Required. Text; maximum UTF-16 length 8192. Real proleptic Gregorian YYYY-MM-DD; four-digit years 0000-9999 accepted. |
| retestDate | Retest Date | Required. Text; maximum UTF-16 length 8192. Real proleptic Gregorian YYYY-MM-DD; four-digit years 0000-9999 accepted. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| earlierDate | Earlier supplied date; expiry chosen on equality. Retest is not treated as a replacement expiry. | Required. Text; maximum UTF-16 length 8192. |
| label | Label | Required. Text; maximum UTF-16 length 8192. |
{
"input": {
"lotId": "LOT17",
"expiryDate": "2026-12-01",
"retestDate": "2026-11-01"
},
"output": {
"earlierDate": "2026-11-01",
"label": "LOT17 [2026-11-01]"
}
}Limitations and assumptions
- This compares dates only; a retest date is not a new expiry or release decision, and material suitability is not checked.
- Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
Alternative or Complementary methods
Reconcile item-level dispatch, receipt, return and inventory ledgers against physical stock and lot records. Use actual package dimensions, handling plans and release documents when a quantity margin alone cannot answer an operational question.
References
Similar or alternative tools
- Instrument Calibration Age
Measure signed calendar days since a supplied instrument-calibration date.
- Oral Surgery Sterile Pack Expiry
Measure a sterile pack's margin to its printed expiry date.