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.

Example

To see the Date/Time difference between two dates:

1. Multi-select two date columns
2. Right-click either column header
3. Select Quick Calculation > Date > Date Difference