Reverse NOT counting weekends and holidays for a date range

[tincan56]

Hi, I have been looking everywhere for this solution, however, have not been finding any. Most people want to exclude weekends and holidays.

Unfortunately, our system already does that, but I need to
include holiday and weekends as a regular non-holiday week day. How would I be able to do so?

Thanks so much for your help!

 

[synapsevampire]

If you want to include everything, you shouldn't need to filter at all.

The best solution to this in the long term is to build a Periods table which has all dates, with flags for non-working days.

Now you can use this table for your joins.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com