I received a data export in CSV. The date time structure is a bit strange. I just need a date and time I don’t care. The format here is 04JUN21: 11: 17: 16 I chose the first 7 characters of 04JUN21 to convert them via string to date & time to date. Unfortunately, NODE can’t recognize it. Can you explain that to me? [image] Knime forum data format.knwf (42.9 KB) I enclose the workflow.

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: [image] String to date format: 21MAR2025 KNIME Analytics Platform 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…

Date format in csv can not be recognize

KNIME Analytics Platform

Thyme April 12, 2022, 11:02am 5

The root cause for that confusion is how Java parses the strings, it’s not a KNIME issue. KNIME AP version 4.4 onwards uses a different Java version. Maybe you can try to use the legacy mode mentioned here:

No promises though, as that thread is about capitalistion of AM/PM in different locales.

A bit more info: