reidwalley
Member
Desired result: To produce a monthly report that shows both Active and Expired memberships.
Setup: I have 3 LEFT JOINS. One table contains "subscription_date" column; another table contains "expiration_date" column. And I have a Range Filter on each column's date element.
Test: (On the front-end) using the Range Filter on the "subscription_date" column, I pick [between] Aug 1, 2016 [and] Aug 31, 2016, and think this will display all Active and Expired memberships for the month of Aug 2016.
But this is not what happens. The "subscription_date" Range Filter only displays memberships that are Active during the month of Aug 2016 (which makes sense) - but it doesn't show any of the Expired memberships during the month of Aug 2016.
How can I use Range Filter to display Active and Expired memberships for a monthly report? Or am I way off base?
Setup: I have 3 LEFT JOINS. One table contains "subscription_date" column; another table contains "expiration_date" column. And I have a Range Filter on each column's date element.
Test: (On the front-end) using the Range Filter on the "subscription_date" column, I pick [between] Aug 1, 2016 [and] Aug 31, 2016, and think this will display all Active and Expired memberships for the month of Aug 2016.
But this is not what happens. The "subscription_date" Range Filter only displays memberships that are Active during the month of Aug 2016 (which makes sense) - but it doesn't show any of the Expired memberships during the month of Aug 2016.
How can I use Range Filter to display Active and Expired memberships for a monthly report? Or am I way off base?