I am looking to understand how I can find out the company joining date for an employee with multiple contracts.
Situation: the employee joined in January 2017 with contract A until December 2019, then he got a different job inside the company with a new contract B until today.
The hiring date for the employee is shown from the current contract B start, what I need is the overall period of the employee being employed in the company until today taking into consideration start date of contract A which is not valid anymore.
This is a very normal requirement in any company and I can't seem to figure it out.
Any help is highly appreciated.
Thanks,
David