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.

 

 

 


Thanks & Best regards,
Medi

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);

Thanks & Best regards,
Medi

View solution in original post

29 REPLIES 29

@niveditakumari 

 

I hope you are doing well!

Did it work ? Was my reply helpful?


Thanks & Best regards,
Medi

Hi @niveditakumari.

I hope you are doing well! 

Did this work? Could you please close this thread!


Thanks & Best regards,
Medi

@niveditakumari 

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


Thanks & Best regards,
Medi

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!

 

 

 

 


Thanks & Best regards,
Medi