Declare @FromDt Datetime, @ToDt Datetime
Set @FromDt = '1/1/08'
Set @ToDt = getdate()
select * from mytable
where
DATEDIFF( d, @FromDt, myDateField) >= 0 and DATEDIFF(d, @ToDt, myDateField) <= 0