Get Previous Month and Year (Variable Expression)

[gonhaddock]

Hello @bruno29a
P stands for Period
I am defining a window of 2 items; starting point is the system time; and the stepping period is minus 1 month P-1M.

Here there is another example from previous post stepping by negative days:

Setting date in the rule based row filter to Today's Date minus X days

Hello @datascienceduck In KNIME you have to create the TODAY’s Date with ‘Create Date&Time Range’ node with the following configuration (from system time, 5 five days window backwards -current minus 4-): [image] Then you can select the minimum with GroupBy and send it to a variable. You can use this variable in your logical tests along the workflow. [image] 20221222_today_minus_x_v0.knwf (20.3 KB) $Date&Time$ = $${SMin(Date&Time)}$$ => TRUE TRUE => FALSE BR

@bruno29a

What happens if you are on March 31st?

This is the good thing, KNIME handles the calendar. Things like this + integrate scripting made me love this platform.

BR