המרת תאריך במשפט SQL בשליפה מאקסס

להלן השאילתה
הבעיה היא במשתנה FilterDate:

FilterDeptID = MDI_MainForm.cboDeptList.ItemData(MDI_MainForm.cboDeptList.ListIndex)

FilterDate = Format(MDI_MainForm.DTP_SelectDate.Value, "MM/DD/YYYY")

strSqlAvailableStaff = "SELECT QryEmpList.Emp_EmpID," _
                                              & "QryEmpList.Dep_DeptID," _
                                              & "QryEmpList.EmpName," _
                                              & "QryEmpList.Occ_OccName" _
                              & " FROM QryEmpList" _
                              & " WHERE (((QryEmpList.Emp_EmpID) Not In    SELECT QryEmpList.Emp_EmpID"_  
FROM QryEmpList" _
                              & " INNER JOIN (Tbl_WorkScheduling INNER JOIN Tbl_ShiftIndex" _
                              & " ON Tbl_WorkScheduling.SI_ShiftIndexID = Tbl_ShiftIndex.SI_ShiftIndexID)" _
                               & " ON QryEmpList.Emp_EmpID = Tbl_WorkScheduling.Emp_EmpID" _
                               & " WHERE (((Tbl_WorkScheduling.WS_Date) = " & FilterDate & ")" _
                               & " AND ((Tbl_WorkScheduling.SI_ShiftIndexID) = 2))" _
                              & " GROUP BY QryEmpList.Emp_EmpID))" _
                      & " AND ((QryEmpList.Dep_DeptID)=" & FilterDeptID & "))" _
                      & " ORDER BY QryEmpList.EmpName;"
                      

בברכה
איריס