- Type: TableInput DataA table with at least two Date&Time columns for the start and end date of time periods. Each row should describe a period in time for which fractional years can be measured.
This component computes the fraction of the year of the difference between two dates, similar to the YEARFRAC function in Microsoft Excel. The component outputs two columns: - The "YEARFRAC" column contains the difference between the start date and the end date as a fraction, that is the number of whole days between the dates divided by the total days per year. - The "Difference Value (in Months)" contains the same difference, but given in months. Similarly to Microsoft Excel YEARFRAC function, the output measures depend on the “basis”, a parameter which controls how many days make a financial year.
- Type: TableDifference DataInput data table with additional two columns: the measured fractional years and the same time difference measured in months.
Used extensions & nodes
Created with KNIME Analytics Platform version 4.4.1
By using or downloading the component, you agree to our terms and conditions.