So the lag function that is helping to shave off a day from the count of days to avoid double-counting works when StartDate is used as the beginning date in...

• This reply was modified 3 years, 5 months ago by agorjest.

DateDiff code didn't paste properly in previous post. Here is the correct code:

• This reply was modified 3 years, 5 months ago by agorjest.
• This reply was modified 3 years, 5 months ago by agorjest.

Jeff, to answer you're question, the StartDate (and the EndDate)  can be one of 3 dates, determined by the datediff code earlier in the query (see query snip below).  StartDate/EndDate...