I have a dataset where I need to find:
1. did Identify (field1) occur multiple times within 6 months
2. if there is a second or third occurence as shown in example, how do I find if date 1 of second occurence (8/22/2022 in this ex) is/is not within 5 days of date2 of first occurrence (8/9/2022) is this example,
3. message 3 - is date 1 within 5 days of notificationDate2 from Message 2
| Identify | Message ID | Date1 | NotificationDate2 |
| B123456 | Message 1 | 8/1/2022 | 8/9/2022 |
| B123456 | Message 2 | 8/22/2022 | 8/26/2022 |
| B123456 | Message 3 | 11/8/2022 | 11/9/2022 |
