Now I Get this:
Msg 245, Level 16, State 1, Line 2
Conversion failed when converting the nvarchar value '11/13/1964' to data type int.
SELECT
dimUser.EmpFullName1 [User Name],
dimUser.MgrEmpFullName1 AS Manager,
dimUser.PrimaryJobName AS [Primary Job],
dimUser.EmpNo AS [User Number],
CONVERT(VARCHAR(10), fact.StartDtID, 101) [Start Date],
CONVERT(VARCHAR(10),fact.EndDtID, 101) [Completion Date],
dimUser.PrimaryOrgCode,
dimUser.SecondaryOrg1 AS [Secondary Org 1],
dimUser.SecondaryOrg2 AS [Secondary Org 2],
dimUser.PrimaryOrgName AS Org,
sd.DateDesc AS StartDate,
dd.DateDesc AS EndDate,
dimUser.EmpStat AS [Emp Status],
CASE WHEN fact.completionStatusID = '-1'
THEN 'Not Satisfied'
ELSE 'Satisfied' END AS Status
FROM factAttempt AS fact
INNER JOIN dimActivity AS A ON A.ID = fact.ActivityID
INNER JOIN dimUser ON dimUser.ID = fact.UserID
INNER JOIN dimDate AS DD ON DD.DateID = fact.EndDtID
JOIN dimDate AS SD on sD.DateDesc = fact.StartDtID
WHERE (dimUser.EmpStat = 'active')