Getting the exact time and date when the problem record is updated as Fix in progress

Nandhinisri
Tera Contributor

Hi

How can I fetch the exact time and date of when the state is updated as Fix in progress. We do have updated time which fetches date and time of update in sys_history_line table. But I am not sure how to implement the above said condition and take that particular value.

Nandhinisri_0-1735640255750.png

TIA

1 ACCEPTED SOLUTION

@Nandhinisri 

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

View solution in original post

6 REPLIES 6

@Nandhinisri 

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
Tera Patron
Tera Patron

@Nandhinisri 

what do you want to do after you get the update time?

Do you want to store the exact time in some custom field on problem table?

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