Icon

Convert Excel Dates

Sample Datamismatched date formatsincluding Excel valuesSplit between Excel Values (upper)and DateTime strings (lower)Convert to UnixTimestampConvert to DateTimeActually, we'reconverting to LONG datatyperather than INTbecause ofsize of numbersSupply sequenceto rejoin inorder laterBring rows back togetherPut back in original orderTidy UpChange Invoice Dateto numeric type(Double)so we can use it in Math FormulaStraight conversionto Date&TimeTable Creator Row Splitter Math Formula UNIX Timestampto Date&Time Double To Int Counter Generation Concatenate Sorter Column Filter String To Number String to Date&Time Sample Datamismatched date formatsincluding Excel valuesSplit between Excel Values (upper)and DateTime strings (lower)Convert to UnixTimestampConvert to DateTimeActually, we'reconverting to LONG datatyperather than INTbecause ofsize of numbersSupply sequenceto rejoin inorder laterBring rows back togetherPut back in original orderTidy UpChange Invoice Dateto numeric type(Double)so we can use it in Math FormulaStraight conversionto Date&TimeTable Creator Row Splitter Math Formula UNIX Timestampto Date&Time Double To Int Counter Generation Concatenate Sorter Column Filter String To Number String to Date&Time

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: brian
Created at: 2021-12-22
On NodePit since: 2022-02-06
Last update: 2024-05-01
Created with KNIME version: v4.5.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!