Hi Kurt, Thank you for your answer, but I am not getting the desired result. The long output does not include the 1 or 0 member flag ( 1=Yes and 0=No). On the data Want, I need to select the ID if a person was a member for the 90 days BEFORE the event AND 90 days AFTER the event. So if the event was 2019/02/15 (feb 15th) then the person would have to have been a member for the following 7 months : Nov, Dec 2018 and Jan-May 2019.
... View more