Is it possible to restrict access so only employees' current assignments are visible?

Summary:

Is it possible to restrict access so only employees' current assignments are visible?

Content (please ensure you mask any confidential information):

Hello, our client wants certain HR employees to only see current assignments of specific employees and not their past inactive assignments (and related compensation information). Is this possible to achieve? using security profiles custom criteria or otherwise. Thank you!

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):