How to set up a view to filter on the latest effective date?

The easiest way would likely be to group the view by Employee and then add the effective date as a column. You can then sort by the effective date to find the latest assessment for each Employee.

If you want to see all the latest assessments in one view this likely requires some modification on the objects. For instance, the latest assessment could have a property "Is latest = Yes" which you can then use in your view filter and all the previous assessments would have "Is latest = No". It may be worth reaching out to your M-Files representative if you need help setting this up in an automatic way.

Thanks for the reply Joonas.  Its definitely the later I'm looking for, will work on that - thank you