Calculate age using DOB column

Question

I have dob column how can i calculate age by using DOB column in derived column ? I tried using as below but this throws an error .

 datediff(yy, Dob,getdate()) 

Answer 1

Try using the following expression:

DATEDIFF("yy" , [DOB], GETDATE())

References:

• DATEDIFF (SSIS Expression)