last business day of the month

thats not so easy as you also need to take into account holidays etc.!
One method is to have them in a table!

Nemmeste måde at finde de skæve helligdage på er, ved at gå ud fra Påske.

Pinse er altid 50 dage efter påske. Store Bededag er 4 fredag efter påske.  Påske er første søndag efter første fuldmåne efter forårsjævndøgn - Så du lægger blot påskedag ind i tabellen.

Du kan bruge funktionen DATENAME() til at få leveret dagen udfra en dato. Ved at tage sidste dag i en måned og loope bagud mens du checker for skæve helligdage, så kan du finde sidste arbejdsdag.

trer>do you have a routine to find Easter (påske) ?

Well, Easter is first Sunday after first full moon after spring equinox...  Calculating the full moon is a bit to hairy, I normally just store easter for the next ten years or so in a table.

The other "movable holidays" I then calculate using easter as a base.

No it isnt easy to calculate, and having it in a table is a simple solution. I actually do have a routine in VB, but I'm keeping that to myself :o)

Is it the full routine, using a certain year as a base, and calculating forward from that, or do you have a shortcut?

Implementing the full calculation, especially in T-SQL, have always seems to much bother...

Its the full routine.
Calculation method by mathematician Johann Carl Friedrich Gauss
I actually find it on the web some years back.

heh... I just searched the net, found an algorithm of C.F. Gauá, it is a lot simpler than others I have seen, but limited to the years 1583 to 2299 (actually in sql server the limits will be 1750 to 2250)

Check: http://www.punctum.com/interest/caltime/calend.de.html

Took only a few minutes to rewrite the C procedure to a T-SQL function - and it seems to work...

I think we can manage with 1583 to 2299 (1750 - 2250) dont you :o)

Its years since I played around with C, so I'll keep to my VB, which should also be easy enough to convert to T-SQL if I ever need to!

Link has a couple of other date routines too.

I dapple a bit in generalogy, so it is a rather annoying having those limits. Actually, off hand it seems like the routine does not handle the days removed from the calender in the 1750'ies.

The other routines / algoritms seems interesting as well - i noticed that...

Okay, we have come a bit off topic here - nice "talking" to you, Terry :-)

Det Hjalp mig ikke helt, men gav mig nogle ideer.... Tak for hjælpen :o)