Re: Business days

> - -- I need to get the a total number of business days (from monday to
> - -- friday) between two dates.
> - -- Someone can help me please.
>
> A simplistic approach that counts a "business day" as being Monday
> through Friday would be something like this:

> However, you quickly run into the problem of holidays. While you
> could construct a helper table listing all the holidays, ones that
> don't fall on the same day every year (e.g. Easter) will trip
> you up.

Er, isn't Easter usually on a Sunday? Anyway, I also found this, the
first hit if you google "sql holidays":

http://www.sqlmag.com/Article/ArticleID/25899/sql_server_25899.html

The big ugly union might need to be munged a bit, but most of the non-
weekend US holidays seem to be there.

- John D. Burger
MITRE