Excel Date Serial to DateTime

Converts chosen numeric columns containing Excel Date Serial numbers to datetime.


@takbb Brian Bates 8 July 2022

Options

Choose Excel Date Serial columns
Select all Excel Date Serial number columns to be converted to datetime

Input Ports

Icon
Data table containing Excel Date Serial numbers

Output Ports

Icon
Original Data set with appended columns, with original column names + _dt suffix

Nodes

Extensions

Links

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2022-07-09
Last update: 2024-05-02
Created with KNIME version: v4.6.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!