As I'm leaving for the day and don't have time to create a more robust example, try this on Northwind. Ten bucks says you get the same results...If you don't agree, I'll create another example for you tomorrow.
select * from orders where OrderId in
(select distinct orderid from orders where orderdate >convert(datetime, '07/03/1996', 103)
and orderdate <= convert(datetime, '07/08/1996', 103) + 1)
select * from orders where orderdate >convert(datetime, '07/03/1996', 103) and orderdate <= convert(datetime, '07/08/1996', 103) + 1
-- You can't be late until you show up.