Converting string to hour/day/month/year

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


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

:blush:

5 Likes

Thanks for the quick reply, everything works as it should :slight_smile:

2 Likes

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