Announcement

Collapse
No announcement yet.

Counting members who were active each month

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Counting members who were active each month

    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!

  • #2
    http://stackoverflow.com/questions/1...-current-month that should get you started

    Comment

    Working...
    X