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:
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, 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. | ||
|
Duncan Adamson, Glasgow Dec 25, 2012 |
|
| Worked perfectly thank you! | ||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.