Convert a column in the same date format having two different formats

[enriquesr23]

Hello,

I have a column with two different date formats and I need to put them in the same format.
Can you help me how to do it?

[HansS]

Hi @enriquesr23

Here is one way to answer your question. Split your data based on the date with a Row Splitter, e.g.

With the String to Date&Time node you can adjust the 2 dates (guess data type and format).

See convert_date.knwf (90.1 KB)
gr. Hans