data format

[pjacob]

Hello
I have two format date in my table. first “YYYY-MM-DD” and second “DD-MM-YYYY”, is there any option to replace second format to “YYYY-MM-DD”?

[AnotherFraudUser]

Hi @pjacob,

is there any indication in your table what format is used?
For many dates this cannot be guessed e.g.
09.12.2021
or 03.02.2021

[pjacob]

Hi @AnotherFraudUser actually i have string format but when I tried to convert by “string to date&time” node display error because i have diffrent 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