SQL-SERVER 2012 - Select querries leap year : Leap year! Arghhhhhhhh.
I have a little issue with one my SELECT querries. The entire query is actually is a little long since it includes a UNION ALL. 

    SELECT 'ITV' = CASE WHEN tblIntake.StaffID Is Null THEN '<Unknown>' ELSE
    (tblStaffMember.StaffLast + ', ' + tblStaffMember.StaffFirst + CASE WHEN
    tblStaffMember.StaffMI Is Null THEN '' ELSE ' ' + tblStaffMember.StaffMI END) END, 
    tblMember.[LAST], tblMember.[FIRST], 
    'DueDate' = DATEADD(m, 6,CAST(CONVERT(Varchar(10),
    MONTH(tblIntake.EnrollDate)) + '/' + CONVERT(Varchar(10),
    DAY(tblIntake.EnrollDate)) + '/' + CONVERT(Varchar(10),YEAR(GETDATE()))As
     DateTime)), 'Type' = '6 Month Appt' 

    From tblIntake LEFT JOIN tblStaffMember ON tblIntake.StaffID =
    tblStaffMember.StaffID LEFT JOIN tblMember ON 
    tblIntake.KEY = tblMember.KEY 

    Where tblIntake.UnEnrollDate Is Null AND
    DATEADD(m,6,CAST(CONVERT(Varchar(10),MONTH(tblIntake.EnrollDate)) + '/' +
    CONVERT(Varchar(10),DAY(tblIntake.EnrollDate)) + '/' +
    CONVERT(Varchar(10),YEAR(GETDATE()))As DateTime)) > GETDATE() AND 
    DATEADD(m, 6,CAST(CONVERT(Varchar(10),MONTH(tblIntake.EnrollDate)) + '/' +
    CONVERT(Varchar(10),DAY(tblIntake.EnrollDate)) + '/' +
    CONVERT(Varchar(10),YEAR(GETDATE()))As DateTime)) <= DATEADD(d, 45, GETDATE()) 

SO i have this wonderful query. Everything was running Okay until a user entered a leap year date for ENROLLDATE in tblIntake. How would I go about fixing it? My other UNION do the same SELECT statements with the exception of for when it does 

    CONVERT(VARCHAR(10),YEAR(GetDate()-1)) as DateTime > '4th line from the bottom
    CONVERT(VARCHAR(10),YEAR(GetDate()-1)) as DateTime > '2nd line from the bottom

