Converting string to hour/day/month/year

[blopin]

After executing a String Manipulation module I inserted a String to Date&Time node to format the data to hour/day/month/year. The program does not execute correctly with the date format set as H/dd/MM/yyyy.

With fail on error disabled, the new column only displays the date and time for the year 2012. Starting from the first day of 2013 the values are null. I didn’t manage to find anyone with the same problem as me as I am only working with an hour format. Thanks in advance <3

[armingrudd]

Hi @blopin and welcome to the KNIME community,

It seems your “day” and “month” values are single digits for first 9 days/months, so use this format instead:

H/d/M/yyyy

[blopin]

Thanks for the quick reply, everything works as it should