### Title

How do I calculate non-rounded whole elapsed years?

### Post

I have a date and need to calculate how many whole years have elapsed since that time. I don't want the months or days, just the number of whole years as an integer (so that I can add '1' to the result to give the number of the next anniversary eg 2 full elapsed years + 1 = "Your next anniversary will occur on the (date of anniversary) and will be your third anniversary".

Can you please help? I tried doing a Calculation but couldn't find "Today" or even Get (CurrentDate) which is referenced all through these forums but is not in my FMPA 11 help guide or function list.

All suggestions welcomed!

The following calculation computes age in whole years from a birthdate. It should work to do the same for any anniversary date:

Let ( [ B = YourTable::BirthDateField ;

T = Get ( CurrentDate )

] ;

Year ( T ) - Year ( B ) - ( T < Date ( Month ( B ) ; Day ( B ) ; Year ( T ) ) )

)

Substitute your birthdate field in place of "YourTable::BirthDateField" and make sure that this is a field of type date. Also make sure to select unstored as the storage option for this calculation field or the age will not automatically update as time passes.