Cause Lynn left out some brackets

WITH BaseData AS (

SELECT

rn = ROW_NUMBER() OVER (PARTITION BY EMPLOYEE_ID ORDER BY ADMISSION_DTE DESC),

CONVERT (VARCHAR(9), EMPLOYEE_ID) AS EMP_id,

MAX(CONVERT(DATETIME, (CONVERT(VARCHAR(8), ADMISSION_DTE)))) AS Adm_date

FROM

CurrentTable

WHERE

[BranchID] = '950'

AND ( DISC_DTE IS NULL

OR ( DISC_DTE > 20120630

AND DISC_DTE < 20130201 ) )

)

SELECT

*

FROM

BaseData

WHERE

rn = 1;