I want to update a "Resolved Date" field on a table.

Sathwik1 · ‎02-14-2025

In a table "A" there are two fields., namely Field A, Field B.

Field A = State

Field B = Resolved Date

-> If STATE changes to "Resolved" then I need to update the RESOLVED DATE as current date/time.

I want to achieve it through "Function field" instead of using Business rule or UI Policy or something..

Can someone please help on this ? @Ankur Bawiskar

Ankur Bawiskar · ‎02-14-2025

calculated field calculate every time a row is read.

So if you open incident list and it has 100 rows then the calculated field calculation will be performed 100 times.

I won't recommend doing this.

Since you just want to store then why not use before update business rule and store the current time in custom field.

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

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

Ankur Bawiskar · ‎02-15-2025

Thank you for marking my response as helpful.

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

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

Ankur Bawiskar · ‎02-16-2025

Hope you are doing good.

Did my reply answer your question?

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

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