Hub
ComponentComponent

Fix Numeric Excel Dates

AlexanderFillbrunn profile image

Last edited: 

Drag & drop
Like
Use or download
Copy short link
This component fixes an issue where the Excel Reader outputs a double instead of a date column. The double represents the number of days since 1st of January 1900 and a correct date can be obtained by shifting that day by the given number of days using the Date&Time Shift node. In this component the shifting and column replacement logic is encapsulated.

Component details

Input ports
  1. Type: Table
    Input data
    A data table with a date encoded as days since 01/01/1990.
Output ports
  1. Type: Table
    Output with Date
    A data table with a date column.

Used extensions & nodes

Created with KNIME Analytics Platform version 4.1.3
  • KNIME Core Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.3

    knime
  • KNIME Math Expression (JEP) Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

    knime
  • KNIME Quick Forms Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.3

    knime