Page 1 of 1

Earliest date of the latest ID

Posted: Thu Jul 20, 2017 5:58 pm
by dazz
Hi,

I am trying to get the earliest start time of the latest plan that the person took. In the following, the latest plan is P1, and the earliest start date of it is 06-Feb-2015 . It should therefore return P1 , 06-Feb-2015

ID Date Plan Bundle
100 03-Jan-2014 P1 12
100 13-Oct-2014 P2 07
100 21-Dec-2014 P2 09
100 06-Feb-2015 P1 11
100 06-Nov-2015 P1 13
100 18-Apr-2016 P1 14

Ive tried a few ways to get it, but Im not getting thru. Appreciate any assistance pleaseee

Thanks!

Re: Earliest date of the latest ID

Posted: Thu Jul 20, 2017 7:00 pm
by JimKnicely