How can I exlcude any weekends and/or holidays in a report? I am trying to calculate how long it takes to ship an item from the time the order was taken. 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>
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 Rhinorhino 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
- Thread starter hendoo49
- Start date
gregburningham
Programmer
This is a simple way of doing it<br><br>example<br><br>if to_char(sysdate, 'DAY') in ('SATURDAY', 'SUNDAY') then<br> -- don't include weekends<br>elsif <br> date_in_question in ('14-JUL-2000','15-JUL-2000') <br> -- don't include these days which are holidays<br>end if;<br><br>Cheers<br>Greg B
- Status