WorkingDays Property

The WorkingDays property sets or returns which days are part of the working week.

Syntax

object .WorkingDays(WeekDays)

Applies To

DateDimension Object

DateWizard Object

Discussion

Use the WorkingDays property to specify in one statement all the days that make up a working week. In comparison, you can use the WorkingDay property to determine whether an individual day is part of a working week.

If the time dimension includes a week level, any days specified by the WorkingDays and WorkingDay properties set the days of the week for which Transformer generates categories.

The value you specify for the WeekDays parameter can be values of xtrWeekday joined by plus signs (+), one of the numbers below, or the sum of two or more of those numbers.

  • Sunday = 1
  • Monday = 2
  • Tuesday = 4
  • Wednesday = 8
  • Thursday = 16
  • Friday = 32
  • Saturday = 64

For example, to specify a working week of Monday to Friday, enter either 62 (the sum of 2, 4, 8, 16, and 32), or trMonday+trTuesday+trWednesday+trThursday+trFriday.

For all seven days, enter 127. You can use the WorkingDays property and WorkingDay property in tandem to define a working week.

A COM exception is thrown in error situations. The message that is passed with the exception varies depending on the error situation.

Parameter

Description

WeekDays

Required. Specifies either values of xtrWeekday joined by plus signs (+), or a number that is the sum of one or more numeric values for days of the week.

Note: The way to add the different xtrWeekday joined by a plus sign depends on the implementation language used. For example, in C#, you must do the following:

(int) xtrWeekDay.trMonday 
+ (int) xtrWeekDay.trWednesday
+ (int) xtrWeekDay.trFriday;

Type: Long

Type

Long

Access

Read/Write (DateDimension)

Write (DateWizard)

Examples

objDateWizard = objModel.DateWizardobjDateWizard.WorkingDays(127)