GermanGermanQrew Member11 years agoAge CalculationI have a Date of Report field, a Date of Birth field and next to it we compute Age; how can I fill the Age field automatically based on DOB and the original date of the report?
QuickBaseCoachDQrew Captain8 years agoHere is a formula to calculate age in decimal years. It will be blank if negative. AGE and decimal months // replace the [DOB] field with your date of birth field var date DOB = [DOB]; var number Years = Year(Today())-Year($DOB) - If( Month(Today()) 0, $MonthsDifference, 12 + $MonthsDifference); Var Number Age = Round($Years + $Months/12,0.1) If($Age >= 0, $Age)
Related ContentFormula to display someone's age based on date?Calculate age of childAR aging report/fieldsFormula to Calculate percentage based on Checkmarks and datesCalculate total days with a condition...
Recent DiscussionsCurrent URL Display without JavaScriptRemove the save button when from new forms format when applying I-forms (IFV=1) #354382Help Needed with Quickbase Pipeline to Accumulate Values Instead of OverwritingAPP - CommunicationsKanban WIP Limits