what is the date assigned to of the department managers?
select date_assigned_to from  Staff_Department_Assignments where job_title_code  =  'Department Manager'
date assigned to department managers refers to date_assigned_to; department managers identified by job_title_code = 'Department Manager';