Apr 28, 2021 04:18 AM
I’m running a datediff formula but it’s not displaying the result I’m expecting. I would like the output to include the day itself.
In other words if I’ve got a date range from 28 April to 30 April, for our purposes this is a 3 day event. DateDiff gives 2 days though.
DATETIME_DIFF
({Date ended},{Date started},
‘days’)&" days"
Any thoughts?
Solved! Go to Solution.
Apr 28, 2021 06:21 AM
You can add 1 to the difference
(DATETIME_DIFF(
{Date ended},
{Date started},
‘days’
) + 1)
&" days"
Apr 28, 2021 06:21 AM
You can add 1 to the difference
(DATETIME_DIFF(
{Date ended},
{Date started},
‘days’
) + 1)
&" days"
Apr 28, 2021 07:22 AM
Utter brilliance! Thank you so much.