Issue with the calculation of date type

[anonymous]

I created 2 test virtual column

Column Test 1 with this expression:

Column Test 2 with this expression:

These two of Expressions are logically the same. But the result is different:

There’s something wrong with this calculation. Please check it

[anonymous]

For more information, TODAY() = “10/22/2020”

[Aleksi]

The result of TODAY() - “10/21/2020” is a duration in hours like 24. If you want to convert that as days, you need to divide the result with 24.

[Steve]

For reference:

[anonymous]

So, you mean: TODAY() - “10/21/2020” = 24
But: “10/21/2020” + 1 = TODAY()

[Aleksi]

Correct