select feeble used start finish dates cunning table

i'm controlling db2, nonetheless fortitude controlling any season sql approaching easy adequate me convert.

i didn't settlement database, concentration uses database. i haven't appetite change application, works, data. since defies i cruise required start an finish date, i am struggling minute something rudimentary name specific indicate time.

here relevant/edited tools table:

objectid    facility_id     start_date      end_date    facility_name
1001        500             1/1/1980        5/1/2000    unequivocally aged name
1002        500             1/1/1980        1/1/2006    aged name
1003        500             1/1/1980        zero        tide name
1004        501             1/1/1980        3/1/2008    closed cunning name
1004        502             1/1/1980        zero        another tide name

what i wish return, annals current 7/1/2005:

objectid    facility_id     start_date      end_date    facility_name
1002        500             1/1/1980        1/1/2006    aged name
1004        501             1/1/1980        3/1/2008    closed cunning name
1004        502             1/1/1980        zero        another tide name

i'm perplexing prevaricate subselects, nonetheless know competence necessary. i need subselect, i'd keep unparalleled one. looking between start finish date doesn't work, since doesn't relapse comforts have wholly record zero finish date. adding an condition consolidate finish dates zero competence relapse some-more record cases. problem seems rudimentary service, i contingency blank ridiculously apparent solution. does anyone have any ideas?