The CreatorCon Call for Content is officially open! Get started here.

Approval date

JPSS
Tera Contributor

is it possible to get the approval date when a record in sysapproval_approver table got approved

 

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

@JPSS 

did you check any OOB filed is present on that table?

I doubt there is none.

If the approval is from workflow somehow you can determine based on querying the workflow activities etc and workflow version

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

Hi Ankur,

 

I didnt see any field OOB.

@JPSS 

then it's not possible to track unless you create a custom date/time field on approval table

this field can then be populated using before update BR with current date/time when the state changes to approved

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

Community Alums
Not applicable

Hi @JPSS ,

 I have already answered this on your duplicate question :https://www.servicenow.com/community/incident-management-forum/is-there-any-oobt-field-to-capture-ap...