New function that counts only business days in date calculations

Caroline Blanchard

When creating date calculations, sometimes including weekends causes the new measures to be inaccurate. For example, when counting the time in between a submission date and an approval date, it is not completely accurate to include the weekend days as no one will be working and approving on those dates.

Perhaps a function called Weekdays() or BusinessDays() could be created to more accurately measure the time it takes for approval.

Gabby Rubin-Oracle

Business days is a fluid definition. It might be different from one region to the next and in most industries will require knowledge of specific holiday schedules. Here is an old but still useful forum thread on this topic: https://forums.oracle.com/ords/apexds/post/calculation-of-business-day-in-obiee-1689