How are the date columns in submittal custom reports calculated?

Answer

  • Approver Due Date Variance

    • When a Submittal is Closed, this column is equal to Approver Return Date - Approver Due Date

    • When a Submittal is Open, this column is equal to Current Date - Approver Due Date

  • Approver Returned Date Duration

    • When as Submittal is Closed, this column is equal to Approver Returned Date - Approver Sent Date

    • When a Submittal is Open, this column is equal to Current Date - Approver Sent Date

  • Ball in Court Duration

    • When a Submittal is Open, this column is equal to Current Date - Ball in Court Sent Date