I think that it would make sense, based on what I’ve gathered so far, is to use the membership creation date.
Since, if I understand the records in the memberships table, is that a membership record is created for the member or program or club.
It be in the PersonMembership’s table for the person’s memberships info or the OrgMembership’s table to get the club / program memberships info.
But that these tables retain memberships when the membership is created, correct?
If so, then it makes the most sense to use the creation date of the membership info in these said tables.
This means you would get the number of memberships when they were created each month during your fiscal year.
Would that be correct as to what you’re looking for?
As initially, since I’ve been working with a lot of reports based on PaymentDate, I was getting the number of memberships when they paid, the month they paid them. But since the programs do not pay dues, the PaymentDate does not make sense for the programs.