Hold Pickup Window Explicit Calendar Tool

Description

Count open entries until requiredOpenDays and return that date, otherwise an empty deadline and found false.

Calendar-day differences need real dates and a stated time basis. Fixed clock offsets, supplied working-day lists, and Gregorian date arithmetic answer different questions.

Count open entries until requiredOpenDays and return that date, otherwise an empty deadline and found false.

When to use this tool

Use Hold Pickup Window Explicit Calendar when you need explicit day or clock arithmetic with known inputs.

How to use the tool and how it works

Enter dates, open, requiredOpenDays. Keep parallel arrays aligned. Use the units and conventions below.
Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
Read pickupDeadline, found. Inspect found before interpreting the associated values.

Require aligned open flags and strictly increasing real YYYY-MM-DD dates. Count open entries until requiredOpenDays and return that date, otherwise an empty deadline and found false.^[1]

Input field	Meaning and units	Accepted input
dates	Dates	Required. Array of text; maximum UTF-16 length 8192; maximum items 256.
open	Open	Required. Array of boolean; maximum items 256.
requiredOpenDays	Required Open Days	Required. Safe integer; minimum 1.

Output field	Interpretation	Returned shape
pickupDeadline	Pickup Deadline	Required. Text; maximum UTF-16 length 8192.
found	Whether the requested row, date, or transition was located; inspect this before using fallback output.	Required. Boolean.

json

{
  "input": {
    "dates": [
      "2026-10-26",
      "2026-10-27",
      "2026-10-28"
    ],
    "open": [
      true,
      false,
      true
    ],
    "requiredOpenDays": 2
  },
  "output": {
    "pickupDeadline": "2026-10-28",
    "found": true
  }
}

Limitations and assumptions

The supplied calendar need not contain every consecutive date; found must be checked before using the empty-string placeholder.
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.
Numeric calculations use binary floating point unless exact decimal-integer arithmetic is explicitly stated. No hidden measurement tolerance or decimal rounding is added; nonfinite or out-of-contract results are rejected. Numeric signed-zero results are exported as zero.

Alternative or Complementary methods

Use an authoritative calendar and timezone source when holidays, local dates, or civil-time transitions matter.

References

Calculation and input contract: library-science/hold-pickup-window-explicit-calendar — tool.io

Similar or alternative tools

Lending Renewal Due Date Gap
Parse strict real YYYY-MM-DD dates at UTC midnight.
Settlement Working Day Gap
Validate suppliedEligibleDates as real YYYY-MM-DD dates, count distinct strings for availableDays, and subtract requiredWorkingDays for gap.