Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • knime
  • Spaces
  • Examples
  • 00_Components
  • Financial Analysis
  • Measure Fractional Years
ComponentComponent

Measure Fractional Years

Last edited: 

Drag & drop
Like
Use or download
Copy short link
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 nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.1

  • Go to item
    KNIME Javasnippet Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.1

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

    KNIME AG, Zurich, Switzerland

    Version 4.4.0

  • Go to item
    KNIME Quick Forms Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.1

  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

Legal

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

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits