RE: Custom field calculation


I am currently putting together a test system for our HR team. I have added a few field calculations into some of the fields. One example is for length of service:


This displays the length of service in years. Is it possible to get it to display 1 year and 1 month for example? It seems to only give full years. I can’t figure out the syntax for this.


themelon007 Rookie Asked on August 6, 2020 in Other.
Add Comment
2 Answers

Thank you very much for this. Very useful to know this is a possibility.


I can get it to work up to the point of the full string with years and days, then I get an Invalid Expression error. I have tried moving around the quotes, using double quotes to no avail.


If change the ‘ Years’ for 123 it comes up, so not sure whats going on? Any ideas?

Rookie Answered on August 6, 2020.

Use a text formula

on August 6, 2020.

Perfect thank you!

on August 6, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.