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?
MarkShnierQrew Trainee11 years agothis was posted about a year ago by another user (ddixonr). It looks right to me.I'm assuming here that your field for date of report is called [DOR]The field type would be formula-numeric Year([DOR])-Year([DOB])-1+If(Month([DOR])>Month([DOB]),1,0)+If(Month([DOR])=Month([DOB]) and Day([DOR])>=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