Fixed Assets To and From Period range parameter

Summary:

I'm editing a DM for a fixed assets report. My task is to create a "To Period" and "From Period", the issue is in the SQL no matter how I've written it in to be between Periods it will accept the SQL and create the second Binding Parameter but then when running the report, it will only show a single period, all periods, or the report will run and not show any data.

The report is for Fixed Asset Disposals.

Code Snippet (add any code snippets that support your topic, if applicable):

WITH PERIOD_COUNTER AS(
SELECT fdp1.period_name