CSV Reader interpreting Date as a String

[Delta_Soares]

Hi everybody,

When reading a CSV file through CSV Reader node, it is mistakenly interpreting a Date column (dd/mm/yyyy) as String

I can’t transform it into a Date within the CSV Reader node itself, nor using the String-To-Date node.

Any idea?

CSV File:
20241121_02_42_CART_20241120_V001.csv (15.9 KB)

CSV Reader Config:

String-To-Date Config:

[mlauber71]

@Delta_Soares

dd/mm/yyyy

Welcome to the KNIME forum. You will have to enter the correct pattern where it says “Date format” or use the automatic detection of the correct format to identify the date.