AnsweredAssumed Answered

Find Employee Anniversary Date (calculation)

Question asked by sidetrack_ca on Sep 22, 2017
Latest reply on Sep 22, 2017 by sidetrack_ca

I am trying to calculate an employee anniversary date and return the value to a text field that will ultimately display the following sample text:

"On March 14th, you will reach your 5 year anniversary...Congrats!"

I have the employee start date as a date field called EmployeeStart. I also have a Global variable field called _G.EmployeeAnniversaryDate which is a text field.  this field is where I want to display the result shown above.

 

I have tried several calculations and have yet to get a desired result.  any help in pointing me in the right direction would be super helpful.

 

thanks in advance for any time you use in helping me.

 

Rob

Outcomes