Issue resolved.  I hate to have to dig through someone else's SQL code (especially when it is long and somewhat complicated).

I realized there is something odd with my query.  It is correctly returning one row for a particular date with a smaller date range, but returning two records with an...