I used the following formula provided with modification:
Form.CampDate.Year - BirthDate.Year + (DateTime.Today.Month < BirthDate.Month or (DateTime.Today.Month = BirthDate.Month and DateTime.Today.Day < BirthDate.Day) ? -1 : 0)
I need the return result to show year and month—how do I go about it?
Example: my event date is 06 June 2016 and the birth date is 10 July 2012, so the result should be 3 years 11 month or round to age 3.5 instead of capture as age 4 year. What’s the correct Cognito Forms formula for this result?