Description
Parse actualDate and plannedDate as real Gregorian dates and return actual minus planned in days.
Schedule differences use a common time coordinate and may preserve negative slack or lead times. A scalar lag or float term does not recalculate a full dependency network.
Parse actualDate and plannedDate as real Gregorian dates and return actual minus planned in days.
When to use this tool
Use Project Milestone Date Variance when you need one explicit scheduling or delay-budget component.
How to use the tool and how it works
- Enter plannedDate, actualDate. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read varianceDays. Use the output convention below.
Parse actualDate and plannedDate as real Gregorian dates and return actual minus planned in days.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| plannedDate | Planned Date | Required. Text; maximum UTF-16 length 8192. |
| actualDate | Actual Date | Required. Text; maximum UTF-16 length 8192. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| varianceDays | Variance Days | Required. Safe integer. |
{
"input": {
"plannedDate": "2026-10-10",
"actualDate": "2026-10-13"
},
"output": {
"varianceDays": 3
}
}Limitations and assumptions
- Positive variance means later and negative means earlier; business calendars, contractual deadlines, task criticality, and causes of delay are not evaluated.
- 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 dependency plan and working calendar to assess critical paths, resource constraints, and completion forecasts.
References
Similar or alternative tools
- Continuity Task Recovery Gap
Subtract targetRecoveryHours from measuredRecoveryHours for gapHours and compare measured ≤ target for meetsSuppliedTarget.
- Policy Sunset Notice Date
Parse sunsetDate and subtract noticeDays in 0-100000 using UTC calendar arithmetic.