Generate next day

[sebastian911]

HI,

I want to generate a new column with next day from existing one. How can i do it?

EX:

First Column New Column Difference
1.01.2023 2.01.2023 1
5.01.2023 6.01.2023 1

But, if we want to generate next working day?

2. How can i make difference between this ones? I want to see in int.

[gonhaddock]

Hello @sebastian911
You can create a wide range of working days based in the following workflow (lower branch - first two nodes), you can filter working days (Monday to Friday) with a Rule Based Row Filter node.

Assign working days to month during change of month

Hello @ricobitsch I’ve prepared a workflow deploying the previous idea: [image] 20221208_reporting_month_by_closing_week_v1.knwf (38.2 KB) Let us know if further explanation is needed. Regarding the links, you can drag them from the browser into your KNIME desktop. Besides, they are KNIME base nodes, so you can search by typing in the Node Repository. Building in KNIME to avoid spreadsheet work is really satisfactory, but I recommend you to complete some of the beginners training resource…

Then you can use a ‘Moving Aggregation’ to calculate a Lag(+1) column from the Date&Time column. You will simply need an Inner Joiner node to match lagged column with your $FirstColumn$ data.

BR

PS.- Let us know if further support is needed