IF with date formula

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

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:

3 Likes

Well done @elsamuel! Perfect!
Thank you!

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.