Excellent information!

My actual scenario is a little more complicated so the code I displayed was specifically written for this forum to eliminate project specifics.

We are using variables, have no fear....

Thanks, for the catch there Jeff. You are right in that I was missing the last day's results.

Also, since I only need a month's worth of data at...

Thanks for the great responses!

Based on your suggestions I ended up constructing a query that uses a Common Table Expression to create a temporary table of dates to...