Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Count days and weeks to include start date and end date

367 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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