Hi, I would like to delete a duplicate if a customer has purchased something, and then within 30 days purchases again. (Doesn't matter what kind of purchase.) I have a table with non-duplicate and duplicate customer numbers (CustNo). In one column I have CustNo, in another Date. The table is sorted by CustNo then Date. I want to make a new table where I have removed duplicates with these conditions: 1. CustNo=CustNo 2. The date is in within 30 days before the next date. If there is no next date for that CustNo then keep. E.g: CustNo Date 123 01/11/18 123 15/11/18 123 25/11/18 123 05/12/18 123 10/01/19 456 20/11/18 Want outcome: CustNo Date 123 05/12/18 123 10/01/19 456 20/11/18 I'm on version 7.1 Thanks 🙂
... View more