Date parse

[Danny_77]

Hello Everyone,

I have dates in various formats as strings. How can I convert all of them to a consistent date format in a single node in KNIME? Any guidance or examples would be appreciated.

[tqAkshay95]

@Danny_77 ,

You can use the following component for parse the different format of dates.

Trouble Converting Date String to Desired Format.

Hi @derron_foo, and welcome to the Knime Forum. if I read correctly, you merely want to replace the month as a number by it’s short name. Here is a possible solution. Though, I’d recommend using aa proper Date type instead of a string as it offers many aadvantages. [image] Here is the test workflow: Best Mike