DateDiff
Measures the gap between two dates, such as days to close a deal or months a loan has been outstanding. The result is the second date minus the first, so it comes back negative when the second date is earlier.
Inputs
| Input | Accepts | Required |
|---|---|---|
Date1 | Date | Yes |
Date2 | Date | Yes |
Unit | Text | Optional |
Outputs
| Output | Produces |
|---|---|
Result | Value (a single number) |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
Unit | Days | One of Days, Hours, Months, Years. Days and Hours measure the exact gap and can be fractional. Months and Years compare calendar positions and ignore the day of month: January 31 to February 1 counts as 1 month, and December 31 to January 1 counts as 1 year. |
Example
To measure sales cycle length, set Date1 to the opportunity's Created_Date
(2026-01-05) and Date2 to its Close_Date (2026-02-21). With Unit on Days
the result is 47: the deal took 47 days to close. Compare that against your
team's target cycle, or average it across the quarter's deals.