Write the following code to get your work done ..... make sure that you enter the date in single quotation then only it will work properly .... or else it will not work as you expect it to work .... but at the same time it will not throw you any error also .....
so please make sure that you use the quotation while entering the date
SELECT *
FROM table
WHERE @date >= startdate AND @date <= enddate