Fetch latest row in Assignment in When & Why section

Summary:

Hi Team,

We have a requirement where we need to validate start date for change assignment workflow (When and Why).

User can select Manager change action only with a minimum of 30 days gap from prior Manager change action.

we have written the below code to fetch the all the rows related to Manager change as below for an employee, but how do we fetch the latest row (Effective start date & Effective end date) for manager change transaction?

Content (required):

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

21D

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