Brian Dunning's FileMaker Custom Functions

Age ( DOB )

Converts date of birth to an age in years

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

Chris Stasny   Chris Stasny

Share on Facebook Share on Twitter

  Sample input:
Age ( 6/29/1954 )
  Sample output:

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

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



David Head   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   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   Lee Smith
Oct 12, 2009
and a CF already exist with this calculation, see
Matt   Matt, Vermont
Nov 12, 2009
Another age calculator. Just what we need.
Duncan Adamson   Duncan Adamson, Glasgow
Dec 25, 2012
Worked perfectly thank you!

Log in to post comments.


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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: