Creating MONTHLY data from two different dates


I have dataset in which one column has start date and other has end date along with other columns. Also the dates in each row of these two columns are different. I need to convert this data into Monthly data. Is there a node in knime which can help to do this?

Thanks for your help!


Hi Zaeem,

we would need more details what you need to do. But there will not be one node for it. But a composition of some of them. Did you already try the exisiting nodes? The Time Difference could calculate the difference between the two dates. The Date field extractor tells you which month and year your date is in and the groupby node can afterwards calculate you mean values for each month.

Cheers, Iris