How to Set Up an Aging Report

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.

Action Enabled

The action enabled by this report will allow you to apply more resources to the "Old" submissions.

Sample Report

Aging Report lg

Report Definition

Database Table:

services

Search Criteria:

'l_Status' = "Draft" or 'l_Status' = "In Progress" or 'l_Status' = "Pending Approval"

Fields Displayed:

  • Form: c_formSlug
  • Status: l_Status
  • Submitted: c_submittedAt
  • Updated: c_updatedAt

Calculated Fields:

  • Confirmation #: To display the Confirmation # I built a Calculated Field to display the last six characters of the c_id field:

Confirmation %23

  • 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:

Age Days