I am trying to calculate length of employment for our employees. I've been "successful" in being able to generate two fields - one for # of years and once for # of months. But, what I really need is a single field that shows # of years with a decimal point.
I've used the formula (Today() - [Hire Date])/365 - yielding an adequate result for my needs (# of years with a decimal point) but it is labeled as days not years. (2/25/2022 - 12/15/2017)/365 = 4.2 days
Any assistance would be greatly appreciated as this is driving me nuts and I couldn't find a clear resolution for this topic within the community posts.
Thanks!
------------------------------
Eric Rovner
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.