Calculate Date Difference
Description
Calculates the difference in dates between two columns in specified units (years, months, days, hours, etc.) and stores the result in a separate column.
Input
Data only
Output
Transformed Data
Configuration Fields
-
Start date Date column specifying the start date
-
End date Date column specifying the end date
-
Difference units Specifies the user selection for the units of difference required
-
Output column Name of the column to store the calculated differences
-
Include original
- If true Includes the data rows from the previous activity along with the output column.
- If false Provides only the output column.
Sample Input
| id | name | enrollmentDate | lastAccess | dob | graduationDate | Enrollment date new |
|---|---|---|---|---|---|---|
| 1 | Alice Johnson | 2023-01-15 | 01/15/2023 | 2002-05-10T00:00:00 | 2026-05-15 | 01/15/2023 |
| 2 | Bob Smith | 15-02-2023 | 15-Feb-2023 | 2003/04/12 | 2027-05-20 | 02/15/2023 |
| 3 | Charlie Brown | 2023.03.10 | 10 Mar 2023 | 10-06-2001 | 2025-12-30T23:59:59 | 03/10/2023 |
| 4 | Daisy Adams | 2023/04/01 | April 1, 2023 | 2000-09-21T12:30:00Z | 2024/06/15 | 04/01/2023 |
| 5 | Ethan Carter | 05-May-2023 | 2023-05-10 | 1999.12.15 | 2024-11-01 | 05/05/2023 |
Sample Configuration
Sample Output
| id | name | enrollmentDate | lastAccess | dob | graduationDate | Enrollment date new | Total years |
|---|---|---|---|---|---|---|---|
| 1 | Alice Johnson | 2023-01-15 | 01/15/2023 | 2002-05-10T00:00:00 | 2026-05-15 | 01/15/2023 | 3.33 |
| 2 | Bob Smith | 15-02-2023 | 15-Feb-2023 | 2003/04/12 | 2027-05-20 | 02/15/2023 | 4.26 |
| 3 | Charlie Brown | 2023.03.10 | 10 Mar 2023 | 10-06-2001 | 2025-12-30T23:59:59 | 03/10/2023 | 2.81 |
| 4 | Daisy Adams | 2023/04/01 | April 1, 2023 | 2000-09-21T12:30:00Z | 2024/06/15 | 04/01/2023 | 1.21 |
| 5 | Ethan Carter | 05-May-2023 | 2023-05-10 | 1999.12.15 | 2024-11-01 | 05/05/2023 | 1.50 |
| 6 | Fiona Green | 2023-06-20T08:00:00Z | 20-06-2023 | 1998/07/07 | 2023/12/31T23:59:59Z | 06/20/2023 | 0.53 |
| 7 | George Hill | 2023.07.25 | 25th July 2023 | 1997-03-03 | 2024-10-20T09:30:00+00:00 | 07/25/2023 | 1.24 |
| 8 | Hannah Lewis | 2023-08-15 | 08/15/2023 | 1996/11/11 | 2024-08-15T16:00:00+00:00 | 08/15/2023 | 1.00 |
| 9 | Ian Moore | 15-09-2023 | 15th Sep 2023 | 1995-01-01 | 2025-07-01 | 09/15/2023 | 1.79 |
| 10 | Jenny Owens | 2023/10/10 | October 10, 2023 | 1994.06.30 | 2026-03-15T10:45:00 | 10/10/2023 | 2.43 |