How to use DAYS in formula?

Platform discussions Special workflows & use cases
1

I’m having problems with the following formula to get the number of days between Today and a date column:

days(today(),{Request Date})

Results are coming back with decimals, for example Today is 5/24/2021 and my request date is 5/25/2021, so logically is just 1 day, but system is returning the value as 1.87

can you help me?

Thank you!

2

hi @antonioro Welcome to the community!

To solve this just use the Round, RoundUp or RoundDown function :
Round(days(today(),{Request Date}),0)

That will give you a whole number