Date format in csv can not be recognize

[bruno29a]

Hi @MarekV , the MMM format recognizes the capitalized version of what you have. So Jun instead of JUN, and Nov instead of NOV.

Just convert the month to Capitalized via the capitalize() function in the String Manipulation.

Here’s further details:

String to date format: 21MAR2025

Hi @versatilka and welcome to the Knime Community. The format MMM for month supports the format of Jan, Feb, Mar, etc for month, which is basically the capitalized version of what you have (MAR vs Mar). So you can just capitalize the month via the String Manipulation like this: join(substr($column1$, 0, 2), capitalize(substr($column1$, 2, 3)), substr($column1$, 5)) This should give you 21Mar2025 You can now use the String to Date&Time node to transform this into a date type using the Date fo…