How to calculate date field to show years in another field?

(0) Share

Report

Posted on by USA80

Hello,

I have a date field called Hire Date and for example, this field has the date of 1/1/2012.

Then I have another field called, "# of years with current employer"

I need something that would calculate the Hire Date field to today's date and just show the number of years in the "# of years with current employer field"

So for this example it would show 10.

It would then need to be ran daily on all employee records.

How can I do this?

Thank you.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hi USA80,

You can achieve it through calculated field, The following are my test steps:

Step1: Set the Hire Date field to Date and Time type and the # of years with current employer field to Whole Number Type, and add the set two fields to the form.

Step2: Define calculated columns.

Step3: The test results show that it can be achieved.

Was this reply helpful? Yes No