Hi,
I have a data that needs to identify which team does an employee assigned to based on a date.
Example:
Employee A started with Team Red (01/01/2017).
On 02/02/2017, employee was transferred to Team Blue.
On 04/16/2017, employee was transferred to Team White.
On 06/12/2017, employee was...