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”)
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.
You can check out both here:
Well done @elsamuel! Perfect!
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.