Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calculate the Difference Between two dates excluding weekends and Holidays

user10441472Nov 22 2010 — edited Nov 23 2010

Hi,
We need to calculate the difference between the two dates by excluding the Local public holidays (It is global and varies across countries) and weekends should not be included in calculation for a business day in OBIEE.

We have two dates: Open date and close date when ever close date is null we are calculating age based on taking the current timestamp and need to exclude the weekends and Holidays when ever the close date is null.

Ex:
Col1 col2 Total
11/9/2010 2:46:38 PM Null 13
11/2/2010 8:06:26 PM 11/3/2010 5:37:03 PM 1
(In the Total we shouldn't include the weekends,holidays)

Please let me know how to calculate the difference between two dates by excluding the weekends and holidays.

Thanks

Edited by: user10441472 on Nov 22, 2010 3:14 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2010

Added on Nov 22 2010

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

1,485 views