SELECT * from Tablename where date bwtween(@startdate AND @enddate)

@startdate , @enddate will be the two parameters passed from your program as parameter in which you stored values  dates from calender.

I am also not an expert, maybe someone else can further tell a better way.