Icon

kn_​forum_​27849_​excel_​number_​to_​date

convert excel number (or string) to date

convert excel number (or string) to date

original solution by https://forum.knime.com/u/quaelerhttps://forum.knime.com/t/noob-help-convert-date-value-to-dd-mm-yyy/19757/4?u=mlauber71 shift the excel start dateaccording to thedate from stringuse 01-01-1900as excel start dateconvert excelString date to integer(Date&Time)Node 24shift the excel start dateaccording to thedate from stringconvert excelString date to integer Date&Time Shift Table Creator String ToNumber (PMML) String to Date&Time String to Date/Time(legacy) Date/Time Shift(legacy) String ToNumber (PMML) original solution by https://forum.knime.com/u/quaelerhttps://forum.knime.com/t/noob-help-convert-date-value-to-dd-mm-yyy/19757/4?u=mlauber71 shift the excel start dateaccording to thedate from stringuse 01-01-1900as excel start dateconvert excelString date to integer(Date&Time)Node 24shift the excel start dateaccording to thedate from stringconvert excelString date to integerDate&Time Shift Table Creator String ToNumber (PMML) String to Date&Time String to Date/Time(legacy) Date/Time Shift(legacy) String ToNumber (PMML)

Nodes

Extensions

Links

Download

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

Download Workflow
Created by: loki
Created at: 2019-11-29
On NodePit since: 2020-10-06
Last update: 2024-04-18
Created with KNIME version: v4.2.2
Tags: exceldatenumberintegerstringto

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

Try NodePit Runner!