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.

@Danny_77 , You can use the following component for parse the different format of dates. [image] Trouble Converting Date String to Desired Format. KNIME Analytics Platform 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

Date parse

KNIME Analytics Platform

tqAkshay95 June 19, 2024, 10:10am 2

@Danny_77 ,

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

2 Likes