Criteria - find all occurrences in 6 months

[bh1789]

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

[ShankerV]

Hi @bh1789 

Got your question, how is the output expected.

Many thanks

Shanker V

[FinnCharlton]

Hi @bh1789,

This should help solve your problem: