Ok.. Here's my query:

SELECT * FROM [MyDateTable]

WHERE StartDate >= CONVERT(DATETIME, '02/01/2007')

AND StartDate <= CONVERT(DATETIME, '01/04/2008')

This works fine, Jeff! Which is why I was saying, I used Matt's ''don't convert your date field to string'' and I used your ' operators instead of the BETWEEN'.

Do you think I've gotten the point now? 🙂