Display Employee's Age in Years, Months and Days

Scenario

Create a custom Entity field that computes for an employee’s age in year(s), month(s) and day(s).

Solution

Birth Date: 4/12/1987
Custom Field Output: 31 Years 9 Months 26 Days (as of 2/4/2019)

1. Navigate to Customization > Lists, Records, & Fields > Entity Fields > New

2. Label = Age

3. Type = Free-Form Text

4. Store Value = F

5. Applies To subtab > Employee = T

6. Display subtab > Subtab = Human Resources

7. Validation & Defaulting subtab > insert the formula below in the Default Value field
   
   FLOOR(ROUND((({today} - {birthdate})/365.2425),2))||(' ')||('Years ')||FLOOR(ROUND((((ROUND((({today} - {birthdate})/365.2425),3))-FLOOR(ROUND((({today} - {birthdate})/365.2425),3)))*12),3))||(' ')||('Months ')||FLOOR(ROUND(((ROUND((((ROUND((({today} - {birthdate})/365.2425),4))-FLOOR(ROUND((({today} - {birthdate})/365.2425),4)))*12),4)-FLOOR(ROUND((((ROUND((({today} - {birthdate})/365.2425),4))-FLOOR(ROUND((({today} - {birthdate})/365.2425),4)))*12),4)))*31),4))||(' ')||('Days')

8. Click Save