Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Count days and weeks to include start date and end date

1133 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Courtenay_Ricke
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Community - probably super simple, but I have looked through and done searches but I still can’t figure it out.
I’m using DATEDIFF to find the number of days between two rental dates, but it is not counting the end date, ie hire date of 12-Apr thru 16-Apr counts 4 days, not 5.

I think the same goes for outing weeks too. Any solutions please?

Thanks,

1 Reply 1

Correct. The logic there is that if you wanted to add the counted days to the original, you would add 4 days to go from the 12th to the 16th.

Add 1 to the result:

DATETIME_DIFF({End Date}, {Start Date}, "days") + 1