Hi, I’m working on a dataset with dates and I’m quite new with knime. The date column is written like YYYY-MM.DD and my goal is to aggregate the date by week and month.
First, I used the String to Date&Time node in order to have the date in correct data type.
Then, I tried to used the Date Field Extractor (legacy) node to perform the grouping I intended to do. But when I configure the node I get an error saying “No column in spec compatible to DateAndTimeValue”
Am I missing something? And if it isn’t possible to use the date extractor with my data, could anyone suggest me another way of tackling this problem?
Legacy means there is a new/defferent node with this functionality or a new version of this node. In your case you are looking for Extract Date&Time Fields