IF with date formula

[FabioGuimaraes]

Hi Guys

Local date time column can be used in a fórmula with one Knime node?
The point is, I have two date columns “Start Vacation” and “End Vacation”. I would like to understand wich person is on vacation. In excel I used =IF(AND(TODAY()>“Start Vacation”,TODAY()<“End Vacation”),“VACATION”,“ONLINE”)

Any help?

Best

[elsamuel]

There are a few ways to accomplish this, I think.
One is to use the Date&Time Input node to create a variable with today’s date, then use the Rule Engine node to do the comparison.

Another way is to use some javascript inside the Column Expressions node to create today’s date, followed by an “if” function to make the comparison.

You can check out both here:

IF with date formula – elsamuel

[FabioGuimaraes]

Well done @elsamuel! Perfect!
Thank you!