Sorry about that stupidity. Think I figured it out.

select * from leavetable where startdate <= ?vp_end and enddate >= ?vp_start

Does that appear correct for getting all dates?

Thanks!