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.
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?