You need to pass two dates to your report and use them in your select sql statement.
Sample:
SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;
Depending on the report type/controls you are using, try to find how you can pass Date parameter to your report and how you can use it in the SQL statement Or update the question with report control details you are using.