We have this view in our database

SELECT

staffID,

DOB,

CONVERT(datetime, '' + CAST(YEAR(GETDATE()) AS VARCHAR) + '-' + CAST(MONTH(DOB) AS VARCHAR) + '-' + CAST(DAY(DOB) AS VARCHAR) + '', 120)...