We're looking for a way to run a report on folks who have changed their membership level (from Assoc to Pro in our case) for a selected timeframe. This would provide us the ability to see how our membership is trending - whether they're making gains in the industry such that they could be considered 'Professional'.
From a back-end perspective, I think it'd be a matter of:
- adding two database columns (MEMBERSHIP-PREVIOUS-LEVEL and MEMBERSHIP-PREVIOUS-CHANGE-DATE)
- Figuring how to populate those columns on initial member creation (blank or default to initial level and join date)
- Updating code so that when a member's level is changed; their current member level is pushed to the aforementioned previous level column, and the date field is updated with the date of the change
- Writing a query that searches the two new columns for the prescribed date range.