Is it possible to send MAX seniority date
Summary:
Scenario 1: Employee hired on 01/01/2020 and terminated on 30/04/2020 —> seniority date is 4 months
and rehired on 01/08/2020 and terminated on 31/12/2020 —→ seniority date is 5 months
again rehired on 01/01/2024 and Active employee till date —> seniority date is 8+ months
REQUIREMENT:
Get the max seniority date which is combination of all past records (4months + 5months+ 8 months= 1Y 5months)
Scenario 2:
Here, the requirement is to get max seniority date which is 4y 5m 5days
Code Snippet (add any code snippets that support your topic, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):