[Order Date]-Today()

teamMedina · 09-18-2019 06:23 PM

I want to show the result of [Order Date]-Today() and the result I get is a weird number 435775:00:00,

I am expecting
Order Date= 9/15/19
Today()= 9/18/19
Result= 3 (not 435775:00:00)

Please help
What am I doing wrong?
Tony

Suvrutt_Gurjar

Does the following expression help?

(HOUR([Order Date]-TODAY()))/24

For dates earlier than today, you may wish to use an expression

(HOUR(TODAY()-[Order Date]))/24 for result to be positive as you have mentioned.

teamMedina

YES!!! That worked!! Thank you sooo much SG, made my day.
Cheers