com (com) writes:
The mistake you are making is to forget that getdate() includes a time
portion as well.
convert(char(8), getdate(), 112) BETWEEN StartDate and FinishDate
would be better.
I am here assuming that StartDate and FinishDate have their time portions
Erland Sommarskog, SQL Server MVP, se
Books Online for SQL Server SP3 at