Extracting month, day and year from a Date variable

Does KNIME have a node to automatically extract month, day, year, etc from a Date/Time variable?

I use for this purposes Cell Splitter. May be there is another best way, but this works well for me.
Best regards, Max

Hi vivek, hi max,

using the cell splitter is more a workaround as we already have a quite nice DateandTime variable in KNIME. You can find nodes for this variable time in the section Time Series.

In those you can at first use a StringtoDateTime node to parse your string containing the date/time.

Afterwards use the Date Field Extractor to extract month, day, year, etc. There is also a Time Field Extractor for hours, minutes, and so on.

Best regards, Iris

1 Like

Thanks Iris & Max!