Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Weekends and Holidays

Status
Not open for further replies.

hendoo49

MIS
Jul 22, 1999
5
US
How can I exlcude any weekends and/or holidays in a report?&nbsp;&nbsp;I am trying to calculate how long it takes to ship an item from the time the order was taken.&nbsp;&nbsp;We currently just subtract the date entered from the date shipped but this does not take into account any weekends or holidays.<br><br><br>
 
This is a simple way of doing it<br><br>example<br><br>if to_char(sysdate, 'DAY') in ('SATURDAY', 'SUNDAY') then<br>&nbsp;&nbsp;&nbsp;-- don't include weekends<br>elsif <br>&nbsp;&nbsp;&nbsp;date_in_question in ('14-JUL-2000','15-JUL-2000') <br>&nbsp;&nbsp;&nbsp;-- don't include these days which are holidays<br>end if;<br><br>Cheers<br>Greg B
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top