Managing Weekdays

From the Interval Manager Home page, you can manage your weekday configuration, including the first day of the week and the label for each day of the week. The first day of the week that you define here must be the same as the first day of the week in your Microsoft SQL Server configuration.

EXAMPLE 

Jack’s SQL Server configuration gives Sunday as the first day of the week (the default for US English). As such, Jack ensures that Sunday is also given as the first day of the week in the Interval Manager.

Warning: You must correctly set up your weekday configuration before doing anything else in the Interval Manager! If SQL Server and the Interval Manager each consider a different day to be the first day of the week, then any interval groups that you add will not be correctly set up.

Note: Once set up, you should not need to edit your weekday configuration.

For more information about the first day of the week in SQL Server, see https://docs.microsoft.com/en-us/sql/t-sql/statements/set-datefirst-transact-sql.

To edit your weekday configuration, follow these steps:

  1. From the Interval Manager Home page, click Edit for the first record in the WEEKDAY table. The Edit Weekdays page is shown.

  2. In the box, type the name of the first day of the week.

    Note: This must be the first day of the week in your SQL Server configuration.

  3. Click Save.
  4. Repeat steps 1–3 for the other days of the week.