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?
ArchiveUserQrew Captain11 years agoYou are right. I couldn't figure out how to modify. Below formula works. (Year(Today())-Year([DOB])-1)+If(Month(Today())>Month([DOB]),1,0)+If(Month(Today())=Month([DOB]) and Day(Today())>=Day([DOB]),1,0)
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