I would like to get the total # of active members per month, for each month in the last 2 years. i have their effective date and some have a cancel date. (those that don't have cancel date are still active).
So if someone became member in June and canceled in November, he was active for June, July, August, September, October, November. He would be included as an active member in those months.
I want to count the number of active members in each month. then i want to go to the next month and do the same thing for 24 months.
So if someone became member in June and canceled in November, he was active for June, July, August, September, October, November. He would be included as an active member in those months.
I want to count the number of active members in each month. then i want to go to the next month and do the same thing for 24 months.
