select getdate ()

CAST(a.ACTIONDATE_QLR AS DATE) BETWEEN '2020-07-01'
			AND '2020-09-30'

CAST(a.ACTIONDATE_QLR AS DATE) BETWEEN '{ctrl::Start Date}'
					AND '{ctrl::End Date}'

=IF({Use Date Range}="False",acqdate(strcat(DAY(today()-int({Number of Days from today (You are NOT restricted to list)})),"-",MONTH(today()-int({Number of Days from today (You are NOT restricted to list)})),"-",1900+YEAR(today()-int({Number of Days from today (You are NOT restricted to list)}))),"DD-MM-YYYY"),{Start Date::prev})