Attach a dashboard date filter to more than one column

Metabase newbie. Trying what I think should be simple but struggling.

  1. I have a model with rental leases that have 'ActiveDate' and 'InactiveDate' columns.
  2. I want a card on the dashboard that shows the number of leases active on a given date provided by the dashboard date filter.

I think what I need is an additional filter on the question that says "between([dashboard_date_filter, [ActiveDate], [InactiveDate]), however I can't figure out how to reference the filter value in the expression.

How can I accomplish this?


is that a native or a gui question?