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
EducatorsInc
http://EducatorsInc.com

Share on Facebook Share on Twitter

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

  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.

 

Comments

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 http://www.briandunning.com/cf/521
 
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 BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.