Function field to calculate future date - to use in response template

ArpitaVK
Tera Expert

I am working on a response template for an HR case, where I have to print the (hire date + 2 days) date; where hire date = employment start date on the HR profile. For this requirement, I have created a function field with type date on the HR case table. Can someone guide me on how to calculate this date dynamically to populate it in the response template?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron

@ArpitaVK 

so you want to show dynamic value i.e. hire date + 2 days there in response template?

not possible

Workaround: Create a date field and store Hire Date + 2 Days in that, then use that in your response template

AnkurBawiskar_0-1770368946427.png

 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

4 REPLIES 4

Ankur Bawiskar
Tera Patron

@ArpitaVK 

so you want to show dynamic value i.e. hire date + 2 days there in response template?

not possible

Workaround: Create a date field and store Hire Date + 2 Days in that, then use that in your response template

AnkurBawiskar_0-1770368946427.png

 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@ArpitaVK 

Thank you for marking my response as helpful.

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Dr Atul G- LNG
Tera Patron

The functional field does not provide a future date, but creating a new field is also a customization. Please check if there is any existing field available in the HR case that you can use for this purpose. Avoid customization as it will increase technical debt. @ArpitaVK 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************