I'm trying to create an AR balance report that includes customer/clients/accounts beginning and ending balance.

How can I apply a date range filter as a maximum value for the first value  (i.e. capture all records up to that point for one table, and another table to use it as a beginning value?

To do this I currently have to create three different date range filters. One that captures all AR data starting with data entered years ago through the beginning of the month (i.e. 1/1/06 through 10/1/20) . The second date range filter is set to the beginning and ending of the month (i.e. October 1 through October 31). Lastly to collect the ending balance I have to run another date filter from the first date through the ending of the month (i..e 1/1/06 through 10/31/20).

Can this be accomplished with variables?