Issue with the calculation of date type

Maple_Aikon · 10-21-2020 11:16 PM

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

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

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.

Maple_Aikon

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

Steve

For reference:

Aleksi

Correct