How to get the Years & months between two date?

[DynamicsHS]

Hi, 

I want to be able to calculate length of service based on active workers. I used DATEDIFF([Hire Date],[today],YEAR).

This gave me the whole numbers of the year ....but i want it to be able to break down so that if an employee has been with the company for 2 and a half years it will show up as 2.6 rather than just 2 years at the moment. 

is this possible?

Thanks,

HS

[jdbuchanan71]

@DynamicsHS 

You would be very close with 

DIVIDE ( DATEDIFF([Hire Date],[today],DAY), 365)

If you want to keep it to 1 decimal do 

ROUND(DIVIDE ( DATEDIFF([Hire Date],[today],DAY), 365),1)

[ryan_mayu · Accepted solution]

@DynamicsHS 

what about try thsi

DATEDIFF([Hire Date],[today],MONTH) / 12 .

[DynamicsHS]

It worked! Thank you

[ryan_mayu]

you are welcome