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 https://www.bloomington.k12.mn.us |
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.
Comments
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 ) Let ( [ NumberOfDays = Get ( CurrentDate ) - GetAsDate ( DOB ) ] ; Int ( NumberOfDays / 365.24 ) ) |
||
Matt, Vermont 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.