Search this insane blog:

Wednesday, December 30, 2009

Navision showing Monday as first day of week

SQL Server and English-based sql servers have Sunday as the first day of week.
Our Navision day of week is based off of Monday.
but you can set the first workday in SQL Server quite easily by setting the DATEFIRST statement

try this:
http://msdn.microsoft.com/en-us/library/ms187766(SQL.90).aspx

No comments:

Post a Comment