I really can't thank you enough. Thank you for the superb help and explanation. This was stumping me for quite some time.

One more question...

If I wanted to get a DATEDIFF between the two Dates, how would I accomplish that? Many thanks.

Many thanks!

This worked, but I made a temp table for the first part. TBH, I am fairly new to SQL and do not understand the beginning part:

;

;WITH BASE_DATA AS

(

...