Calculation based on year of current date

[zackhughes]

I have been trying desperately to create a field that will subtract the data in my 'BirthYear' field from the year in the current date. This would give me an age that would update itself in the future. I cannot for the life of me figure out the formula. I tried this: BirthYear - Year(CurrentDate) = Current Age but to no avail. The term 'Year (CurrentDate) isn't recognized as a value. Any suggestions?:

Thanks a million in advance.

[Kurt Knippel]

You'll hate yourself for this: it is STATUS ( CURRENTDATE ), so

BirthYear - Year( Status ( CurrentDate ) ) = Current Age