Help

Adding an extra day to datediff

Topic Labels: Formulas
Solved
Jump to Solution
1633 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Oliver_Weedon
6 - Interface Innovator
6 - Interface Innovator

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?

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

You can add 1 to the difference

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

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

You can add 1 to the difference

(DATETIME_DIFF(
  {Date ended},
  {Date started},
  ‘days’
) + 1)
&" days"
Oliver_Weedon
6 - Interface Innovator
6 - Interface Innovator

Utter brilliance! Thank you so much.