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 Number of Working days between 2 dates.

929225Jun 26 2012 — edited Jan 28 2013

Hello Gurus,

I am facing a issue in calculating number of Working days between 2 dates. Working days exclude Weekends and Holidays. I am able to get number of days between 2 dates (Ex: Entered Date and Shipping Date) using TIMESTAMPDIFF function (TIMESTAMPDIFF(SQL_TSI_DAY, "Schedule Line Details"."Entered Date" ,"Schedule Line Details"."Shipping Date"). But my requirement is to get working days. I have a column in Database "DAY_TYPE" which identifies if a day is Working day or Weekend or Holiday (DAY_TYPE = (WD, WE, H).
Any help would be sincerely appreciated.

Thanks

Edited by: 926222 on Jun 26, 2012 2:47 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2012

Added on Jun 26 2012

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

5 comments

1,468 views