Age ( DOB )

Converts date of birth to an age in years

Average rating: 3.8 (43 votes) Log in to vote

Chris Stasny
EducatorsInc
http://EducatorsInc.com

Sample input:

Age ( 6/29/1954 )

Sample output:

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let (
[ 
NumberOfDays = Get ( CurrentDate ) - GetAsDate ( DOB )
]
;
Int ( NumberOfDays / 365.24 )
)

This is a quick calculation that compares todays date to the DOB (Date Of Birth ) parameter. It returns the age in years.

Comments

		David Head, uLearnIT Oct 6, 2009
This calculation is a poor approximation to actual age around a person's birthday. There are much better calculations involving tests for whether the birthday has occurred in the current year.

		comment, VR Oct 7, 2009
I agree. It's not too difficult to calculate the exact age: Let ( today = Get (CurrentDate) ; Year ( today ) - Year ( DOB ) - ( today < Date ( Month ( DOB ) ; Day ( DOB ) ; Year ( today ) ) ) )

		Lee Smith Oct 12, 2009
and a CF already exist with this calculation, see http://www.briandunning.com/cf/521

		Matt, Vermont Nov 12, 2009
Another age calculator. Just what we need.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.