Thanks for your answer but in BOL I don't see any info on how to change the DATEFIRST setting for the server. If I use SET DATEFIRST is will only affect the current session.

Is it possible to change this or do I have to build in some logic to correct this depending on what DATEFIRST returns?

Br,

nic