Hi I'm trying a Qlicksense expression to achieve the below
1. Get only the current and one previous enrollment and end date.
2. Compare the current enrollment date and previous end date if previous end date >6months of current enrollment date then flag ID 1 as new else old.
In the above example rows the output should show as below as solved by @vinieme12
Please advise. Thank you