DATE DIFFERENCE
Description
Will give the mathematical difference of the span between two date columns
Parameters
Options
| Input Parameter Values | Values |
|---|---|
| Time Span Units | Days, Hours, Minutes, Months, Seconds, Years (Required) |
| Only Rollup If | Generic Criteria |
Input
| Date Input | Values | Required |
|---|---|---|
| Input 1 | Date Column or Literal | ✔ |
| Input 2 | Date Column or Literal | ✔ |
The system knows to take the date format value from days and extract only that field.
Remarks
- The default data type of this calculation is integer. When measuring days between columns that contain time, you will want to use a decimal type to capture the fraction of days.
- When using the <NOW> variable in a date difference calculated in Days, the difference will round up if the current time is past 12 PM (Noon).
Example
To see the Date/Time difference between two dates:
- Multi-select two date columns
- Right-click either column header
- Select Quick Calculation > Date > Date Difference