It is the downside of Impromptu. I have deserted because of those issues. You cannot use hints. If you want to use hints, u will loose some functionalies as the query will effectively becomes the pass through query
Short way. (without taking into account of holidays)
Calculate the days difference.
Diff = ToDate - FromDate
Remainder = Diff mod 7
If Remainder = 6 then
Remainder = 5
End If
Working Days = Int(Diff / 7) * 5 + Remainder
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.