data clutter in date in output file

[Ivannia]

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

And this is the way how I see it in CSV

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?

[quaeler]

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?

[mlauber71]

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

Converte Date

Put your scenario in a workflow. The Date manipulation is done with several KNIME nodes. One might also do that with a Java Snippet. With Date fields it is always the question how to store them, either as strings that can universally be stored and loaded or as UNIX timestamps or with the internal KNIME format. You always have to be careful. In a lot of Big Data storages the standard format for dates is: yyyy-mm-dd a lot of programs can interpret that as a date format and even do calculations wi…

[Ivannia]

Thanks a lot, your comment is very assertive !!! I put the data in another reader and I can see the date how it’s supposed to be !!!

Thanks a lot!

[Ivannia]

Thank you!! I will save this example!!! Very useful!!!