Description
Count civil days under a supplied endpoint convention.
Date labels and intervals depend on origins, endpoint inclusion and calendar versus elapsed-time conventions. Numeric serial periods and local token formats can represent useful bookkeeping without resolving a real instant or official fiscal rule.
Count civil days under a supplied endpoint convention.
When to use this tool
Use Date Interval Single Day Closure Label when checking a supplied date-label, duration or interval convention.
How to use the tool and how it works
- Enter start, end, includeStart, includeEnd. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read days, empty. Inspect empty before interpreting the associated values.
Count civil days under a supplied endpoint convention. Validate ordered dates; days = max(0,elapsedDays-1+includeStart+includeEnd), and empty tests zero.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| start | Start | Required. Text; maximum UTF-16 length 8192. Real proleptic Gregorian YYYY-MM-DD; four-digit years 0000-9999 accepted. |
| end | End | Required. Text; maximum UTF-16 length 8192. Real proleptic Gregorian YYYY-MM-DD; four-digit years 0000-9999 accepted. |
| includeStart | Include Start | Required. Boolean. |
| includeEnd | Include End | Required. Boolean. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| days | Days | Required. Safe integer. |
| empty | True for a coincident day unless both endpoints are included; follows the documented discrete-day convention. | Required. Boolean. |
{
"input": {
"start": "2024-01-01",
"end": "2024-01-03",
"includeStart": true,
"includeEnd": true
},
"output": {
"days": 3,
"empty": false
}
}Limitations and assumptions
- Coincident endpoints require both inclusion flags to count one; no business-day or jurisdictional rule is applied.
- 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
Use a complete date/time implementation and the applicable calendar policy for actual scheduling and interval interpretation.
References
Similar or alternative tools
- Date Comparison Partial Precision Overlap
Compare two inclusive possible-date envelopes.
- Date Range Unbounded End Token
Assemble a bounded or open date interval token.