select * from tbl 
where coalesce(actual_start, projected_start, some_deep_past) <= current_date 
and coalesce(actual_finish, projected_finish, some_far_future) >= current_date