Can anyone help me how to capture the Approval time when the RITM has approved by manager

[Likithsai]

Can anyone help me how to capture the Approval time when the RITM has approved by manager. I am sending 1 notification from workflow to the user.

I didnt find any field in the approval table. i want the time when state changes to approved and that time need to write in email script and send notification

[Alikutty A]

Hello,

You can create a new field to capture Approval Date and capture it in the Approval UI Action script.

current.u_approval_date = new GlideDateTime();

Thanks!

[Likithsai]

Thanks, but new field i cannot. I can do getjournal(1) and then trim all the details. 

[Alikutty A]

You can try this script

var gr = new GlideRecord("sysapproval_approver");

//Fetch you approval record in GR for RITM here

if(gr.next()){
  var lastDate = gr.comments.getJournalEntry(1).split(" - ")[0]);
}

[Harish Kumar3]

Hi Gopi,

On RITM table, Field "Approval set" used to capture approval datetime("Approval set" is an OOB field).

"Approval Set" field value populate when "Approval" field marked as "approved".

Thanks,

Harish