Hello, this is my first post. I have a workflow and everything works fine, but today after a little adjustments the order in date is wrong. In knime the date looks good, YYYY-MM-DD, but when I open the output file in folder looks like: D/M/YYYY This is the way how I visualize it in knime [image] And this is the way how I see it in CSV [image] I almost forgot to mention, I use string to date already, and before that worked very well, I don’t understand when its change. Could anybody help me?

Hi & welcome - When you write ‘this is the way i see it in CSV,’ there is some misdirection going on here. I see in the screenshot above that you are looking at the CSV in some program (Excel?) which has read in a bunch of text and made assumptions about what data types are in which cells. Since this is CSV, which is inherently an untyped file format, perhaps you should tell the viewing program the column contains date values - and at that point, in that program, set up how date strings should be formatted for display?

data clutter in date in output file

KNIME Analytics Platform

mlauber71 August 7, 2019, 9:26pm 3

You could check out this discussion and example where we did some manipulations on date values:

2 Likes