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())

score 3 · Accepted Answer · answered Jul 11 '19 at 06:10

3

Try using the following expression:

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

References:

answered Jul 11 '19 at 06:10

Hadi

1 Answers1