Setting the first day of the week
The first day of the week is used in calculations on dates and date parts. A default first day of the week is taken from your system, but can be set to match your needs.
About this task
The first day of the week defaults to <System>:
- For Microsoft™ Access databases the first day of the week is Sunday
- For SQL databases, the first day of the week is derived from the current locale as set on your machine or using the locale ID of the SQL Server machine
This setting only needs changing if the locales on the SQL Server machine and your local machine differ, or you want your week to start on a different day.
Procedure
To change the first day of the week:
- Select .
- On the Advanced page, select the First Day of Week.
- Select OK.