GetAge ( birthdate )
Calculates the number of years, months, & days based on your birthdate
Average rating: 3.9 (48 votes) Log in to vote
Danny Leung - Show more from this author
Bloomington Public Schools
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, MS
Oct 5, 2009
|This is what I use for my Age function
Age (DOB )
NumberOfDays = Get ( CurrentDate ) - GetAsDate ( DOB )
Int ( NumberOfDays / 365.24 )
Nov 12, 2009
|Does anyone check to see how many other functions already exist for exactly the same purpose?|
|Henry Perret - Gentil, Bogotá, Colombia
Aug 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 Colombia
Aug 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.