Changing the date format

Hello,
I need to create a date of a run in a specific format. I used Create Date&Time Range node and it creates a date of yyyy-mm-dd. I need it to be formatted as mm/dd/yyyy. i used String to Date&Time and it keeps failing. What are my other options?

1 Like

Hi there,

to have that format you can do 2 things:

  1. Use legacy Date&Time format. After create Date&Time Range use Date&Time to legacy Date&Time node. Also under Preferences–> KNIME --> Preferred Renderers chose appropriate format.

Date%26TimeRen

  1. Work with strings. After create Date&Time Range node use String Manipulation node to get your format.

Both ways you will not be able to work with new (standard) Date&Time nodes to manipulate Date column(s) so I advise you do this change at the end of workflow.

Br,
Ivan

4 Likes

Ended up doing the string manipulation. Much appreciated!

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.