question Updating date field in previously resolved tickets in Community Central forum

Updating date field in previously resolved tickets

MegC — Mon, 16 Feb 2026 18:40:42 GMT

Hello all,

I am attempting to update a date field when a ticket was changed to resolved state. I was trying to use a glide walker, but I don't see that plugin in our list of installed (unless I'm not looking in the right place). I have checked to make sure that audit is selected on the form in question. I have updated the form so that when the state is marked as resolved it will update the resolved date field correctly, but now I'm trying to updated previously resolved tickets.

The fix script I tried:

Any insight or assistance would be appreciated!

Re: Updating date field in previously resolved tickets

vaishali231 — Tue, 17 Feb 2026 07:08:36 GMT

hey @MegC

try this :

*************************************************************************************************************
If this response helps, please mark it as Accept as Solution and Helpful.
Doing so helps others in the community and encourages me to keep contributing.

Regards
Vaishali Singh

Re: Updating date field in previously resolved tickets

Ankur Bawiskar — Tue, 17 Feb 2026 08:01:42 GMT

@MegC

if table is audited then you can do this

You can do GlideRecord from following tables,

sys_history_set and sys_history_line

For e.g. I am fetching history for incident number 'INC0010016' and getting when State changed to some value from empty

var incident = new GlideRecord('incident'); incident.addQuery('number','INC0010016'); incident.query(); while(incident.next()){ var history = new GlideRecord('sys_history_set'); history.addQuery('id',incident.getValue('sys_id')); history.query(); history.next(); var auditH = new GlideRecord('sys_history_line'); auditH.addQuery('set',history.getValue('sys_id')); auditH.addEncodedQuery("label=State^newISNOTEMPTY^oldISEMPTY"); // new is not epmty and old is empty auditH.query(); if(auditH.next()){ incident.u_field = new GlideDateTime(auditH.sys_created_on).getDate(); incident.update(); } }

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

Re: Updating date field in previously resolved tickets

Ankur Bawiskar — Wed, 18 Feb 2026 03:28:45 GMT

@MegC

Hope you are doing good.

Did my reply answer your question?

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

Re: Updating date field in previously resolved tickets

Tanushree Maiti — Wed, 18 Feb 2026 04:27:34 GMT

Hi MegC,

If Your table/application is having any backend flow/workflow, it is best using that you can store the previous value of your Date field in scratchpad and use that till end of the flow.

You can do it using by hitting audit table if your custom table is audited. BUT it is not at all recommended. it can cause performance issue of your instance in long run.

Re: Updating date field in previously resolved tickets

vaishali231 — Wed, 18 Feb 2026 10:46:29 GMT

hey @MegC

Hope you are doing well.

Did my previous reply answer your question?

If it was helpful, please mark it as correct ✓ and close the thread 🔒. This will help other readers find the solution more easily.

Regards,
Vaishali Singh