age ( birthday )
calculates the correct age
Average rating: 3.4 (39 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
The previous submissions seem to all be in error for age. See if this does the trick.
Daniel A. Shockley, New York, NY
May 4, 2011
This will often be wrong on the day of the person's birthday anniversaries.
Date of Birth = 5/4/2008
Today = 5/4/2011
This function returns 2, when the correct age is clearly 3.
Aug 29, 2017
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.