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

[Nandhinisri]

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.

TIA

[Ankur Bawiskar · 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.

[Ankur Bawiskar]

@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?