Calculate Age from Transaction Date

[sdang]

I looked through all the treads about  calculating age  and found  this line of code:

int(YRDIF(t1.DOB, t1.PlayerDayDate, 'Year'))

The line of code is valid but the column ,AGE, shows missing value or no values. What did I do wrong?

My DOB and PlayerDayDate format are as follow:

22MAR2014:00:00:00

[ballardw · Accepted solution]

The variables have to be DATE valued functions, not DATETIME. Use datepart(t1.dob) and datepart(t1.PlayerDayDate).

I think you want "AGE" as the basis or blank, 'YEAR' should have gotten a warning or error message.

[sdang]

Thank you, it worked!