That's the same date range covered by the test data, so I'm still not 100% clear. You're seeing correct results when run against the test data, but incorrect results when run against the actual data?

If that's the case, I'd have to see the actual data that's causing a problem, as well as the query you're running.

Cheers!