Pending Approval Changes within 48 hours

Requirement is to create a report in change management that lists pending approval changes that are within 24 to 48 hours. What date/time field should I use for this?
Thank you.

  • Hi,

    You can create a new field in approvla table named approval.start.date, fetch the value from cm3r "date.entered" and current.phase="CAB Approval" or whatever it is and save it during add.

    Use the approval.start.date, approval.status and filename=cm3r to get the results in View/reports/dashboards.