I've been trying to solve this for a while but I need some expert help. Attached will find a table "Members".
I'm trying to identify Member ID's, where there were gaps in their Start and End dates. For example, if I were to look at this table manually, Member ID's (J003, A001 and C005) would be flagged or identify because there was a gap in there membership, or it was not continuous for following reasons:
-J003 = Record 6-7 (start 7/1/2014 - end 7/31/2014; start 10/1/2014 - end 10/31/2014). For this scenario it went from end 7/31/2014 to start again to 10/1/2014, thus there was a gap.
-A001 = Record 11-12 (start 2/1/2015 - end 3/31/2015; start 5/1/2015 - end 12/31/9999). For this scenario it went from end 3/31/2015 to 5/1/2015, thus again the gap.
So what I really need to do is idenitify the Member ID where there was a gap in their coverage.
Thank you in advance!