Employee department Change
I have an Employee details module which includes ( Code, Name, Start date, Leave date, Salary, etc.).
There is one more module where the monthly employee salary is shown and we get the salary detail until the employee is employed. I have made a process where the employee has changed departments on a certain date. For example, employee "ABC" transferred from the Sales to the Production department on August 1, 2020. Therefore, until August 2020, the salary will be reflected in Sales, and after the transfer, it will start showing in Production for the "ABC". For this to achieve, I have added the same employee with a different employee ID in the other department and in the new department I want the Start Date to be the Leave Date from the previous department, but I couldn't copy the date using formulas. How can I achieve this?
Thanks in advance for the help!