8
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.
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.
#1
André Arnaud de Cal...
293,280
Super User 2025 Season 1
#2
Martin Dráb
232,046
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
