>SELECT *; > FROM MyTable; > WHERE BETWEEN(MyDate, dStartDate, dEndDate) >
SELECT *; FROM MyTable; WHERE datediff(d,dStartDate,getdate()) between 0 and datediff(d,dStartDate,dEndDate)