this is my sample data. the table has million of customers.my service start date for the car is the main date that I want to use to capture all claims 2 months pre and 2 months post. 60 days pre and post is fair enough. customer service start date service end date type of purchase A 1/1/2017 1/5/2017 Car A 11/21/2016 12/1/2016 Truck A 1/8/2017 1/23/2017 Plane A 6/4/2016 6/6/2016 boat B 1/6/2017 1/9/2017 Car B 11/11/2016 12/4/2016 Truck I created this process below where i imported my table first, i created a query(querybuilder1) to pull the car purchases, than query 2 pull all claims except the car. query 3 combine both tables(i did a join on customer )and filtered within the date that falls 2 months pre and post.i used that function on the service start date from my table 2: -60 < t1.'service start date'n - t2.'service start date'n < 60. the final result(query3) combine both tables but it didn't stack the results, it added them next to each other(not what i wanted, see second picture)
... View more
