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