Display Date Difference of Two Date Fields in Year / Month / Day Format

In the Employee record > Human Resources tab, user entered the Hire Date of the Employee. User would like to create a new field that would display the Tenure of the Employee in the Company. This date will be base from the Current Date subtracted with the Employee's Hire Date.

 

The Tenure should display in format of Year Month and Day.

 

To create the field, perform the following steps:

 

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

           

            2. Provide Label (e.g. Tenure).

           

            3. Set Type to Free-Form Text.

           

            4. Un-check Store Value.

           

            5. In the Applies To tab, check Employee.

           

            6. In the Display tab > Subtab, select Human Resources. Set Display Type to Inline Text.

           

            7. In the Validation & Defaulting tab > Default Value, use (Formula = True) :

           

                        TRUNC (MONTHS_BETWEEN ({now},{hiredate})/12) || ' ' || 'Year(s)' || ' '||MOD(TRUNC(MONTHS_BETWEEN ({now},{hiredate})), 12) || ' ' || 'Month(s)' || ' ' || TO_CHAR(TO_DATE({now}) - ADD_MONTHS({hiredate}, TRUNC(MONTHS_BETWEEN ({now},{hiredate})))) || ' ' || 'Day(s)'

 

            8. Click Save.