Hub
Pricing About
ComponentComponent

Measure Fractional Years

knime profile image
Versionv1.0Latest, created on 
Oct 20, 2023 1:29 PM
Drag & drop
Like
Use or download
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.

Component details

Input ports
  1. Type: Table
    Input Data
    A 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.
Output ports
  1. Type: Table
    Difference Data
    Input 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
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.1

    knime profile image
    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.1

    knime profile image
    knime
  • Go to item
    KNIME Math Expression (JEP)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.0

    knime profile image
    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.1

    knime profile image
    knime

This component does not have nodes, extensions, nested components and related workflows

Legal

By using or downloading the component, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits