Records Request Deadline Sorter
Parse and sort agency request deadlines, identify overdue agencies, and find the next due date.
Description
Sorting request deadlines helps identify overdue records requests and the next upcoming due date.
Sorting request deadlines helps identify overdue records requests and the next upcoming due date. Each supplied record carries an agency and date.1
Parse and sort agency request deadlines, identify overdue agencies, and find the next due date.
When to use Records Request Deadline Sorter
Use this tool to parse and sort agency request deadlines, identify overdue agencies, and find the next due date.
Prepare the text, recorded observations, aligned figures or editorial criteria requested. Confirm what each label, count, timestamp or supplied flag represents before interpreting the result.
How to use Records Request Deadline Sorter and understand its results
- Prepare the text, recorded observations, aligned figures or editorial criteria requested. Confirm what each label, count, timestamp or supplied flag represents before interpreting the result.
- Enter requests, asOfDate using the field table and calculation rules, then run the tool.
- Read sortedRequests, overdueAgencies, daysUntilNextDeadline. The explanation below defines the units, signs, ordering and any flags or placeholder values.
- If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
| Input field | Meaning | Value type; see rules below | Requirement |
|---|---|---|---|
| requests | Agency deadline records | list of string | Required |
| asOfDate | As-of date | string | Required |
Enter agency|date records and an as-of date. Trim and require agencies, parse date strings at UTC midnight, and sort records stably by due timestamp. Extra pipe-separated fields are ignored. Return original sorted records, overdue agency labels in sorted order and next-due days; −1 means none. A due date equal to as-of is upcoming.
overdue=count(due<asOf); daysToNext=ceil((nextDue−asOf)/day) Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| sortedRequests | Requests sorted by deadline | list of string |
| overdueAgencies | Overdue agencies | list of string |
| daysUntilNextDeadline | Days until next deadline | integer |
{
"input": {
"requests": [
"Transit|2025-03-15",
"Police|2025-02-20",
"Parks|2025-04-01"
],
"asOfDate": "2025-03-01"
},
"output": {
"sortedRequests": [
"Police|2025-02-20",
"Transit|2025-03-15",
"Parks|2025-04-01"
],
"overdueAgencies": [
"Police"
],
"daysUntilNextDeadline": 14
}
}Limitations and assumptions
No legal deadline is derived. Empty requests are allowed; native parsing may normalize calendar dates or accept formats beyond YYYY-MM-DD.
Numeric inputs must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Lists are limited to 100,000 entries; the rules above may require smaller limits. Extremely large text inputs are rejected. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.
Alternative or Complementary methods
Use Records Request SLA: Measure a records-request response against a caller-supplied SLA. For a complementary task, use Document Entity Date Sorter: Parse compact document records, sort them by dateline, and collect unique named entities.
References
-
Records Request Deadline Sorter — tool.io
Similar or alternative tools
- Records Request SLA
Measure a records-request response against a caller-supplied SLA.
- Document Entity Date Sorter
Parse compact document records, sort them by dateline, and collect unique named entities.