Description
Parse receivedDate and asOfDate as real Gregorian dates, require asOf no earlier, and return their difference in days.
Public administration records contain identifiers, procedural dates, authorizations, and thresholds. A record formatter or boundary comparison applies the supplied rule without establishing a legally effective decision or complete procedural compliance.
Parse receivedDate and asOfDate as real Gregorian dates, require asOf no earlier, and return their difference in days.
When to use this tool
Use Case Backlog Age At Date when you need one administrative record component under an explicitly supplied convention.
How to use the tool and how it works
- Enter receivedDate, asOfDate. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read ageDays. Use the output convention below.
Parse receivedDate and asOfDate as real Gregorian dates, require asOf no earlier, and return their difference in days.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| receivedDate | Received Date | Required. Text; maximum UTF-16 length 8192. |
| asOfDate | Comparison date in the documented date convention. | Required. Text; maximum UTF-16 length 8192. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| ageDays | Age Days | Required. Safe integer. |
{
"input": {
"receivedDate": "2026-10-01",
"asOfDate": "2026-11-01"
},
"output": {
"ageDays": 31
}
}Limitations and assumptions
- Age does not account for excluded business days, case pauses, statutory deadlines, or service quality.
- 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
Confirm the governing procedure, authoritative record, and any exceptions before relying on a procedural result.
References
Similar or alternative tools
- Work Item Ageing Band
Select the last bound no greater than nonnegative ageDays.
- Backup Snapshot Age
Require asOfTimestampSeconds no earlier than snapshotTimestampSeconds and return their difference.