MAX functions for payroll element effective start date

Summary:

Content (please ensure you mask any confidential information):

Hello experts,

I need to extract the most recent effective start date for a payroll element loaded at the employee level.

I've used MAX(EFFECTIVE_START_DATE) functions but it doesn't work.

How can I properly write the previous condition?

Thanks in advance for your help!

Kind Regards,

Valerio

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

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