1 of 1 people found this helpful
Simplified, the calc is:
Year (Get ( CurrentDate )) - Year (AnotherDateField)
Well, Year (Get ( CurrentDate )) - Year (AnotherDateField) does NOT return 2011 - so perhaps your formula doesn't simplify exactly to that.
Yes Ruben, you're right. Playing around in Data View I was using another field with an almost identical name. This was a number field, not a date field. Replacing it with the correct field does get me the answer I want. Sorry for wasting everyone's time, but thanks for checking it out for me.