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.).
Thank you for the quick response. I receive the following syntax error with the formula above;
Formula syntax errorPlease check the syntax of your entire formula. Possible culprits are a mismatched set of parentheses, missing quotes, or an extra bracket.
That works perfectly, thank you so much.