My client needs to know:
- How many members did we have on date x
- Who were the members on date x
Using "Find memberships" it appears that, though the UI allows it, combining the membership status filter with any of the date filters will return misleading/wrong results. It seems that the query there is using whatever value is in the membership status field at the time you run the report to evaluate against the filter. (Is there a way to tell what query CiviCRM is running?)
How can I best deliver this historical information to my client.
The site in question is running CiviCRM 4.4.14 with Drupal 7.36.