Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

ArpitaVK
Tera Guru

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  ||  10x 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  ||  10x 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  ||  10x 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]

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