combine separate month day year columns

Hello, I currently have 3 separate columns for the month, day and year. I want to combine them into one column for a calendar date. Note, I had to create the Day column using rule engine. Every day is 1. Month is string as is Day and Year. I used a column combiner node, a string to date/time node. However, my result is looking strange. Thanks for any help. Image below of flow and resulting table data.



Hi, I figured it out. I had the format wrong in my String to date time node. Works now. Thanks.


Glad you found a solution, but I would ask - is there any specific reason you are using the legacy version of the nodes?

That is the way it came down from the Knime Forum from an older inquiry. I changed it so no longer legacy.

1 Like

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