If you are looking to find rows with a column value between 2 dates, “BETWEEN” is what you are looking for.
test_expression [ NOT ] BETWEEN begin_expression AND end_expression
SELECT * FROM <Example_Table> WHERE TheDateField BETWEEN '2018-05-15' AND '2018-07-01'
If just dates are specified, the time starts at 12:00AM.
Helpful related links: