RE: Custom field calculation

Home

Answered

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:

(({today}-{hiredate})/365.25)

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.

Thanks,

themelon007 Rookie Asked on August 6, 2020 in Other.

Share
Comment(0)

Add Comment

2 Answers

Votes
Oldest

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?