date cannot change the format

[OliI]

I am a beginner in Knime. I want to change 1987-12-11 to
1987.12.11

I click ok, I get a message,
“Missing value could not parse at index 4”

index 4 is the - sign which cannot be converted to .
Why? What can I do to change this?

Another question:
How can I change 1987-12-11 to 11-12-1987?

[mlauber71]

@OliI welcome to the KNIME forum. Date and Time variables are a standardized internal format that can be displayed in several ways but will internally remain the same:

You can extract the portions of a date and combine it back into a string in any way you like, but it will be a string. You will not be able to use date and time operations on that variable.

Change date format

Hi @Pedro87 This topic has been covered frequently on the forum and elsewhere. For example, this blog is very extensive on date handling To your case, you can approach it from multiple directions. One would be convert it to a date instance, and then convert it to your desired format. [image] Another one would to just directly extract the year, month plus and join it together (through Column Expression, String Manipulation) join(substr(column("FEC_VENCIMIENTO"),8 ,2),"-",su…

Examples how to create a timestamp with the help of math nodes – mlauber71

For presentations or charts it might make sense to convert a date/time variable. Or the report/graphic might be able to handle them in a native way and you specify a rendering in the process.