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?
Re: Pending Approval Changes within 48 hours
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.