calculation for # of years employed

[ljscott]

Hello,

How would i do a calculation for # of years employed? I have a field that is called "date of hire" and figured I'd use todays's date and subtract the two. I need to get an answer with two signigicant figures, like 1.2, 2.5, etc years.

 

[ljscott]

more information.....


we have two fields, "Termination date" and "Current Employee" If an employee is still working with the company, there is no data in "termination date" and "current Employee" is assigned to 'yes' as a result. If the person has left the company, there is data in "termination date" and "current employee" is set to 'no'

 

[D0N]

You should be able to do something like this:
set a variable, say x, to a numberic calculation which is:
(Today- start_date) / 365.
Then, set the formating for x to be "format as decimal" and select "fixed number of decimal digits" and enter a 1 in the box.