First I nee to create a table that shows only weekend dates DD MM YYYY
Second I need to create a table that shows only federal holidays by date DD MM YYYY
Third I need to compare dates that are in my table called ( hist_end and hist_start) against the weekend dates and holiday dates.
If a weekend date or holiday date falls anywhere with in the hist_start to hist_end that date it gets subtracted from the line below
Forth I need to take the dates from hist_end and subtract them from hist_start to come up with a number then add one to it so the date starting is truly counted and then multiply it by 9 for a nine hour work day but if a weeked date or holiday date falls in this time subtract theses dates as needed.
I would like it in SQL format so I can plug it back in to the present asp page that the users are accustom to
This is as far as I got before the change request was asked of me to do larger start and stop date. They had first requested just to subtract weekends from a 7 day start and stop date. Now they want it to look at the total start and stop dates and determin if any of the dates are weekend or holiday day and subtract them from the total count.
SQLStmt = SQLStmt & " CASE WHEN (trunc(b.HIST_END) - trunc(b.HIST_START) + 1) = 6 THEN ((trunc(b.HIST_END) - trunc(b
View Complete Post