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

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?

Hi @enriquesr23

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

With the String to Date&Time node you can adjust the 2 dates (guess data type and format).
afbeelding
See convert_date.knwf (90.1 KB)
gr. Hans

7 Likes