CASE: how to display the right people (directors) depending on date of the mandats?

Above case is a bit of obsolete now; a better one can be found here: