I have a report as follows,
(min date grp) (max date grp)
Name ID Elig Eff Dt Elig Trm Dt
GRP Smith, John M1234567 02/01/2007 12/31/2078
DET1 Smith, John M1234567 02/01/2007 02/01/2007
DET2 Smith, John M1234567 08/01/2008 12/31/2078
Ok, What I need to be able to do is calculate at the detail level the term date on DET1 from the eff date on DET2, the difference betweeen 02/01/2007 and 08/01/2008, I need to be able to show at the grp level that because this time frame is more than 90 days the eff date should actually be 08/01/2008 NOT 02/01/2007.
I need to know the number of days between (DET1 Term Dt) 2/1/2007 and (DET2 Eff Dt) 8/1/2008.
Can this be done and if so any/all help would be appreciated.