Michael Knight
Kilo Contributor

gs.log("Job run::aged approval Rejected:" + new GlideDateTime());

var gr = new GlideRecord('sysapproval_approver');
gr.addEncodedQuery('state=requested^sysapproval.numberSTARTSWITHRITM');
gr.query();
while (gr.next()) {

var gdStart = new GlideDateTime(gr.sys_created_on);
var g1 = new GlideDateTime();

var date_diff = GlideDateTime.subtract(gdStart, g1);
var nDays = parseInt(date_diff.getNumericValue()/86400000);
gs.info('Approval for->' + gr.sysapproval.number + ' ' + nDays);
if (nDays > 7) {
gs.eventQueue('Approval.reminder', gr);
gr.state = 'rejected';

gr.setWorkflow(false);
gr.update();
}
}

gs.log("Job complete::aged approval Rejected:" + new GlideDateTime());

 

Would this do the requirement?