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.