data format

[ipazin]

Hi there @pjacob,

you can split your data using Rule-based Row Splitter node into two data sets based on format date and then for each apply appropriate String to Date&Time node. After them use Concatenate.

Also check here for more ideas:

Date and Time Manipulation

Hello everyone, I am having a date and time column where there were different date formats and this column contains around 110000 rows. I cannot change everything manually in excel and in knime, I cannot make use of legacy date time with multiple date formats. Can anyone suggest with the solution!! Thanks and Regards, Neelima

Br,
Ivan