Calculate Dates Between Today and Specific Date

[James]

Hello!

I would like to calculate the difference between today and a specific data.
Would like to return it in number of days. I tried the method recommended in the feature request (round(currentTime()/86400000-.5,0) - round({Date}/86400000-.5,0)) but it doesn’t seem to work. Anyone can help with this, please?

[Sunny_Singla]

Hello James,

why do you not simply use below?

It’s simple and give proper days

Regards,
Sunny Singla

[James]

Hello,

Great thanks!