I need to count the number of members that have an open auth by month. However, I'm having an issue because I only have an auth begin date and an auth end date. The data looks like this:
Member A
Eff_date = 20071201
End_Date = 20080531
Member B
Eff_date = 20080101
End_date = 20080331
Member A had an open auth every month from 12/07 to 5/08 and Member B had an open auth every month from 1/08 to 3/08. I need it to look like this:
Month Auth Count
12/07 1
1/08 2
2/08 2
3/08 2
4/08 1
5/08 1
I really appreciate your help. I'm at a loss on this one.
Thanks!!
Member A
Eff_date = 20071201
End_Date = 20080531
Member B
Eff_date = 20080101
End_date = 20080331
Member A had an open auth every month from 12/07 to 5/08 and Member B had an open auth every month from 1/08 to 3/08. I need it to look like this:
Month Auth Count
12/07 1
1/08 2
2/08 2
3/08 2
4/08 1
5/08 1
I really appreciate your help. I'm at a loss on this one.
Thanks!!