Fix Numeric Excel Dates

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.

Options

Date Column
The column containing a numeric date representing the number of days since 1st of January 1900.

Input Ports

Icon
A data table with a date encoded as days since 01/01/1990.

Output Ports

Icon
A data table with a date column.

Nodes

Extensions

Links