How to Find Repeated case based on certain condition

[P_Kale]

Hi,

I have a scenario where I want to tagged a policy with a remark "Case_Repeated" if same policy was logged after previous call resolved <= 56 days. e.g. is given below.

Policy_No	Call Logged date	Call Resolved date	Token_no	Repeted_Remark
123457	12-Mar-23	17-Mar-23	A_123
456789	17-Apr-23	20-Apr-23	B_124
123457	12-May-23	17-May-23	A_126	Case_Repeated
456789	19-Jun-23	12-Jul-23	B_123
123457	21-Jun-23	25-Jun-23	A_129	Case_Repeated
456789	26-Aug-23	31-Aug-23	B_127	Case_Repeated
123457	12-Dec-23	01-Feb-24	C_124
234567	09-Feb-24	15-Feb-24	d_123

Thanks in advance

@marcus_sommer 

@swuehl 

@Anil_Babu_Samineni 

[marcus_sommer]

Results from 1 - 13 shouldn't be. But I just notice that it seems that you want not compare the date from the current record against the previous record else difference between logged-date and resolved date. In this case the Offset-calculation should be look like:

call_logged_date - call_Resolved_date as Offset 

[P_Kale]

Thanks for your help @Anil_Babu_Samineni 

[P_Kale]

Thanks @marcus_sommer for your help. Able to resolve not exactly as per above logic but I have used your part logic and build further on it which helps to resolve issue.