Two issues:
1. The syntax for that type of query would be a WHERE clause with a BETWEEN x AND y criterion. You would probably want to synthesize the query using substitution, or you could have those two dates in form controls, in which case you could reference the form controls in the SQL. Note, however, that the "build via substitution" ends up running better most of the time. We also don't know how you intend to use the dates (i.e. for display, for update, for report generation, for select export...)
2. You need to understand DATE fields (and DATE variables, for that matter). They must be handled specially in any query, particularly when dealing with manually entered date and time taken from ANY text-oriented input source (like a text box or an input box or the automated parameter box associated with SQL's undefined parameters.)
We cannot tell your level of expertise so it is hard to know the best way to frame a more detailed answer.