Dates must be enclosed in single quotes in SQL Server. Use date functions
to build queries like the one you describe. Here is an example that works
in the pubs sample database:
select
ord_date
from
sales
where
ord_date between '9/13/94' and dateadd(dd, 7, '9/13/94')
--
Bob Pfeiff
MCDBA, MCSD, MCSE, MCT, SQL Server MVP
Practice Leader, Data Management
CIBER, Washington, DC