I have to calculate years of working.

[niveditakumari]

Hi @shivatmika_19, 

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

It is not working. 

Please find attached screenshot : 

Please help me to correct that. 

Regards, 

Nivedita 

[Medi C · Accepted solution]

@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.

[niveditakumari]

Hi @Ankur Bawiskar, 

It is on sys_user table. 

We don't use any table in email script. 

Regards, 

Nivedita 

[Ankur Bawiskar]

@niveditakumari 

so notification is on sys_user table.

Is that field also on sys_user?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[niveditakumari]

Hi @Ankur Bawiskar, 

Yes my notification is on sys_user and field is on sys_user table. 

My notification is working as expected. 

Regards, 

Nivedita 

[Ankur Bawiskar]

@niveditakumari 

for the record you are testing has some date in it?

Basically you want to find difference in years between 2 dates?

your line 15 should be updated as this as you are using wrong date object for current date.

var currentYear = currentDateGd.getYearNoTZ();

If my response helped please mark it correct and close the thread so that it benefits future readers.

[niveditakumari]

Hi @Ankur Bawiskar, 

Thank you so much it worked for me. 

I need to calculate and show that as per below screenshot : 

 

Can you please help me to achieve that. 

Regards, 

Nivedita