Previous Topic

Next Topic

Book Contents

Book Index

Calculating business days versus number of days

The - (difference in days) operation determines the total number of days between the date value in the report element and another specified date.

To calculate the number of business days between two date values:

  1. Create a - (difference in days) calculation.
  2. From the original calculation, create a new calculation (product) that multiplies the difference calculation by .7142857142857 (this represents 5/7).
  3. From the product calculation, create a new calculation that adds .5 to the product.
  4. From the addition calculation, create a new calculation that rounds the result.
  5. Delete the difference, product, and addition calculations from the report.
Copyright © 2012 - 2015 Oracle and/or its affiliates. All rights reserved.