Shopping Cart

Search:

Signup

Contact

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

# FileMaker Pro Custom Functions

GetAge ( birthdate )

Rate this function:

Discuss this Custom Function

Danny Leung, Bloomington Public Schools
http://www.bloomington.k12.mn.us

Calculates the number of years, months, & days based on your birthdate

Sample Input:
 GetAge( Date(9; 2; 1972) )
Sample Output:
 36 years, 9 months, & 30 days

Then copy & paste into FileMaker Advanced's Edit Custom Function window.

## Description:

This is a much easier way to calculate the age with years, months, & days based on the birthdate you provided.

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

This is my Custom Function and I want to edit it

## Discuss:

Today = 7, 6, 2009

GetAge ( date( 7;5;2008) ) = 1 years, 12 months, & 1 days

One year and 12 months? Huh?? Needs some work!

Needs Work, Washington D.C.
July 06, 2009 1:09pm

This is what I use for my Age function

Age (DOB )

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

Chris Stasny, Oxford, MS
October 05, 2009 3:48pm

Does anyone check to see how many other functions already exist for exactly the same purpose?

Matt, Vermont
November 12, 2009 7:02pm

If ( Month ( Get ( CurrentDate )) < Month (DATEOFBIRTH) ; Year ( Get ( CurrentDate ) ) - Year (Fecha Nacimiento ) - 1 ; Year ( Get ( CurrentDate ) ) - Year (Fecha Nacimiento ) )

Henry Perret - Gentil, BogotÃ¡, Colombia
August 26, 2010 3:24pm

If ( Month ( Get ( CurrentDate )) < Month (DATEOFBIRTH) ; Year ( Get ( CurrentDate ) ) - Year (DATEOFBIRTH ) - 1 ; Year ( Get ( CurrentDate ) ) - Year (Fecha Nacimiento ) )

Henry Perret - Gentil, Bogota Colombia
August 26, 2010 3:24pm