select * from table1 where <FirstDate Passed> between startdate and enddate and <Second Date Passed> between startdate and enddate

this will give u the second record as expected