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