I have a table of members. Each has a start_date and most have an end_date. I need to generate a report that shows the number of active members for each.
That is to say that for each month, I would need to check to see if the start date is before the current month and if the end date is after the current month (or not defined).
I’m sure there’s some brilliant way to automate this, but I don’t know what it would be.
Thanks for any tips or thoughts!