The Aging report will show a listing of all Submissions that are in an "Open" Status and display Confirmation Number, Form Name, Status, Age, Create Date, and Updated Date.
Note: Click the images to see larger versions. You may then need to click to zoom in.
The action enabled by this report will allow you to apply more resources to the "Old" submissions.
'lStatus' = "Draft" or 'lStatus' = "In Progress" or 'l_Status' = "Pending Approval"
- Form: c_formSlug
- Status: l_Status
- Submitted: c_submittedAt
- Updated: c_updatedAt
- Confirmation #: To display the Confirmation # I built a Calculated Field to display the last six characters of the c_id field:
- Age (Days): To display the Age (Days) I built a Calculated Field to display the difference between the current date and the c_submittedAt date: