Fraction of the Year

This component computes the fraction of the year of the difference between two dates.

It outputs two columns: the computed difference between two dates relatives to years, and a columns with the difference in months. This current component only accepts the NASD method to compute the difference.

Options

StartDate
Please Select Start Date column. It must be a date and time column.
EndDate
Please select End Date column. It must be a date and time column.
Calculation Method
Enter Description

Input Ports

Icon
Data with at least two date type columns.

Output Ports

Icon
Input data with additional two columns: the computed difference between two dates relatives to years, and a columns with the difference in months.

Nodes

Extensions

Links