I have to calculate years of working.

niveditakumari
Mega Sage

Hi @shivatmika_19

 

I have written code and added below code to calculate years. 

It is not working. 

Please find attached screenshot : 

 

niveditakumari_2-1740941280843.png

 

niveditakumari_1-1740941167146.png

 

niveditakumari_0-1740941098056.png

 

Please help me to correct that. 

 

Regards, 

Nivedita 

 

 

2 ACCEPTED SOLUTIONS

@niveditakumari 
Please use the following content: 

Congratulations on ${mail_script:yearsOfWorking} Amazing Years, ${first_name} ${last_name}

Dear ${first_name} ${last_name},

Today marks a special milestone for ${first_name} ${last_name}'s ${mail_script:yearsOfWorking}-year work anniversary at ACME South America! Over the years, ${first_name} ${last_name} has consistently contributed their qualities/skills to our team.

From leading successful projects in department Product Management to mentoring new team members, ${first_name} ${last_name} has been an invaluable part of our journey." Your commitment and hard work have made a lasting impact, and we're so grateful to have you as part of our ACME South America family.

Let's all take a moment to congratulate ${first_name} ${last_name} and celebrate their incredible journey with us. Here's to many more successful years together!

Thank you for being an inspiration and for all the contributions you've made. Happy Work Anniversary, ${first_name} ${last_name}!

Signature:

Aruna,

Human Resource Manager.

I believe I've addressed all of your questions. If you're satisfied with the solution, kindly click the thumbs up and accept my answer to close this thread.

 

 

 


If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.

View solution in original post

@niveditakumari 

If you are using DateTime field please adjust the script as follow:

var hiringDate = current.u_hr_hire_date;
var hiringDateGd = new GlideDateTime(hiringDate);
var currentDateGd = new GlideDateTime();
var hiringYear = hiringDateGd.getYearUTC();
var currentYear = currentDateGd.getYearUTC();
var experience = currentYear - hiringYear;
template.print(experience);

If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.

View solution in original post

29 REPLIES 29

@niveditakumari 

 

I hope you are doing well!

Did it work ? Was my reply helpful?


If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.

Hi @niveditakumari.

I hope you are doing well! 

Did this work? Could you please close this thread!


If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.

@niveditakumari 

Kindly close this thread if your issue is resolved! Or let me know how I can support further.


If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.

Hi @Medi C

 

I need to add number of years in subject.

Can we add email script in subject, then we can show 'Congratulations on your 2 birthday' in subject not in email content. 

 

niveditakumari_0-1741863816259.png

 

 

Regards, 

Nivedita 

 

 

@niveditakumari 

  • Remove the subject from your notification
  • Adjust the email script by setting the subject from there

 

var hiringDate = current.u_hr_hire_date;
var hiringDateGd = new GlideDateTime(hiringDate);
var currentDateGd = new GlideDateTime();
var hiringYear = hiringDateGd.getYearUTC();
var currentYear = currentDateGd.getYearUTC();
var experience = currentYear - hiringYear;

email.subject = "Congratulations on your" + experience + "birthday";

template.print(experience);

 

  •  Ensure your email script is being referenced on your notification content (body)

This thread has been ongoing for quite some time, and I believe all your queries have been answered. Kindly mark those as helpful and accept a solution to close this thread!

 

 

 

 


If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.