When generating reports, if an employee has moved departments, can the report reflect their department based on the date of the change?
The report should use the employee's department that was applicable at the relevant date, rather than their current department. This would ensure historical reports remain accurate and reflect the correct departmental information at the time.
