# GetAge ( birthdate )

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

 Danny Leung - Show more from this author Bloomington Public Schools https://www.bloomington.k12.mn.us

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

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

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

 Needs Work, Washington D.C.Jul 6, 2009 Today = 7, 6, 2009 GetAge ( date( 7;5;2008) ) = 1 years, 12 months, & 1 days One year and 12 months? Huh?? Needs some work!
 Chris Stasny, Oxford, MSOct 5, 2009 This is what I use for my Age function Age (DOB ) Let ( [ NumberOfDays = Get ( CurrentDate ) - GetAsDate ( DOB ) ] ; Int ( NumberOfDays / 365.24 ) )
 Matt, VermontNov 12, 2009 Does anyone check to see how many other functions already exist for exactly the same purpose?
 Henry Perret - Gentil, BogotÃ¡, ColombiaAug 26, 2010 If ( Month ( Get ( CurrentDate )) < Month (DATEOFBIRTH) ; Year ( Get ( CurrentDate ) ) - Year (Fecha Nacimiento ) - 1 ; Year ( Get ( CurrentDate ) ) - Year (Fecha Nacimiento ) )
 Henry Perret - Gentil, Bogota ColombiaAug 26, 2010 If ( Month ( Get ( CurrentDate )) < Month (DATEOFBIRTH) ; Year ( Get ( CurrentDate ) ) - Year (DATEOFBIRTH ) - 1 ; Year ( Get ( CurrentDate ) ) - Year (Fecha Nacimiento ) )

Note: these functions are not guaranteed or supported by BrianDunning.com. 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: