Friday, September 21, 2018

Calculate the Age of Employee in Years

To create the custom field, perform the following steps:

     1. Navigate to Customization > Lists, Records, & Fields >  Entity Fields > New.
     
     2. Provide a Label (e.g. Age).
     
     3. Set Type as Integer Number.
     
     4. Uncheck Store Value.
     
     5. In the Applies To tab, check Employee.
     
     6. In the Display tab, set the following:

  • Subtab: Human Resources
  • Display Type: Inline Text

     7. In the Validation & Defaulting tab, set the following:

  • Default Box:  (({today}-{birthdate})/365.25)
  • Formula: Yes

     8. Click Save.


Note: Enter the date of birth in the Birth Date field located in the Human Resources tab.

No comments:

Post a Comment