Solved

Adding an extra day to datediff

+6

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?

Best answer by kuovonne

You can add 1 to the difference

(DATETIME_DIFF(
  {Date ended},
  {Date started},
  ‘days’
) + 1)
&" days"

+29

You can add 1 to the difference

(DATETIME_DIFF(
  {Date ended},
  {Date started},
  ‘days’
) + 1)
&" days"

+6

Utter brilliance! Thank you so much.

Sign up