I would like to show the amount of time an employee has been employed. We have the following date fields;
[Date of Hire]
as well as a checkbox field ([Active]) for if they are active.
If they have been terminated, it should be termination date-date of hire, but if they are still active, we would like it to be today()-date of hire.
I do not know if the formula field should be Numeric or Duration, but we prefer the end number to be in years (1.5, 3.1, 0.8, etc.).