Hi, I need your help solving this issue: I have client_id with multiple date of service and I need to place in between the correct range of dates, the date that client make a payment, so for example: Table 1 Client DateOf Service m1256 5/2/2013 m1256 7/4/2013 m1256 11/1/2014 m1256 5/11/2015 k5678 3/4/2016 k5678 8/16/2017 r2983 5/6/2015 r2983 12/22/2015 r2983 4/29/2016 table2. Payments Client Payment m1256 5/16/2013 m1256 6/28/2016 k5678 5/14/2016 k5678 7/23/2016 r2983 7/3/2015 r2983 3/1/2016 r2983 5/23/2016 I think I can rank the dates in table 1 and stablish start and end date, maybe? Any help will be awesome!
... View more