Sorry mkeintz. Focused on other things and finally i got time to revisit to give fix and it worked perfectly. Thanks mkeintz and everyone. ... View more

We concern about below cases ONLY, Case1: When Lockin_start < elig_ start and Lockin_Stop <=elig_stop then we report this record since part of Lockin date range is outside elig_start range. so it will be like this, Ineligible_start_date =Lockin_start_date; Ineligible_stop_date=Elig_start - 1; Example Case#1 INPUT; ABC1,09/02/2010,10/14/2010,04/16/2010,09/29/2010 OUTPUT:One record of Ineligible time frame. 04/16/2010,09/01/2010   Case2: When Lockin_start >= elig_ start and Lockin_Stop > elig_stop  then we are reporting this record since part of Lockin_stop date is outside elig_stop date. so it will be, Ineligible_start_date=Elig_stop_date+1; Ineligible_stop_date=Lockin_Stop_date; Example Case#2 INPUT; ABC1,12/01/2009,08/22/2010,04/16/2010,03/29/2012 OUTPUT:One record of Ineligible time frame. 08/23/2010,03/29/2012   Case3: When Lockin_start < elig_ start and Lockin_Stop > elig_stop  Here BOTH Lockin_start and Lockin_stop has partial date range outside the eligibility period. so this has to be handled by two records;  Ineligible_start_date= Lockin_start_date; Ineligible_stop_date=Elig_start_date - 1; Ineligible_start_date= Elig_stop_date+1; Ineligible_stop_ date=Lockin_Stop_date; Example Case#3 INPUT; ABC1,08/23/2010,09/01/2010,04/16/2010,03/29/2012 OUTPUT:Two records of Ineligible time frames. 04/16/2010,08/22/2010                 09/02/2010,03/29/2012 OR Inelig_startdt_01 Inelig_stopdt_01 Inelig_startdt_02 Inelig_stopdt_02 04/16/2010,08/22/2010                 09/02/2010,03/29/2012 ... View more

Its extract from DB2 table. its fine to have either format mmddyy10 or $10. ... View more

Here are some more example for  better understanding of expected results. PARTCIPAN, Elig.Start Dt,Elig.stop.Dt,Lockin start Dt, Lockin Stop Dt ABC1,09/02/2010,10/14/2010,04/16/2010,03/29/2012 ABC2,08/23/2010,09/01/2010,04/16/2010,03/29/2012 ABC3,12/01/2009,08/22/2010,04/16/2010,03/29/2012 Expected output: ABC1,09/02/2010,10/14/2010,04/16/2010,03/29/2012,04/16/2010,09/01/2010  *Apr162010 till sep 1st is out of eilg. date range ABC1,09/02/2010,10/14/2010,04/16/2010,03/29/2012,10/15/2010,03/29/2012  *though its lockin partial covered but since Oct15                                                                                                                                till Mar29 are out of elig. date range.       ABC2,08/23/2010,09/01/2010,04/16/2010,03/29/2012,04/16/2010,08/22/2010 ABC2,08/23/2010,09/01/2010,04/16/2010,03/29/2012,09/02/2010,03/29/2012 ABC3,12/01/2009,08/22/2010,04/16/2010,03/29/2012,08/23/2010,03/29/2012   *Comments ... View more