Normalising date formats for conversion


(Knime newbie here)

I have a string column with data in several date formats - some records are in dd/MM/yyyy whereas others are yyyy-MM-dd. I want to be able to cast the column as a date, and change any out of range/null dates to a fixed date value. I’ve experimented with various nodes with little success.

Would be grateful if someone could provide me with some pointers. Would the best thing be to use something like a java snippet?



I would recommend take care of exceptions/nulls first then in a loop use DateExtractor.

1 Like