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:

  1. Select File > Database Properties.

  2. On the Advanced page, select the First Day of Week.

  3. Select OK.