EndWhichWeek Property (DSTStyle)

Reference> DSTStyle Object> DSTStyle Object Properties> EndWhichWeek Property (DSTStyle)

The EndWhichWeek property is used to determine the number of the ending week for the DST within a month.

Syntax

object.EndWhichWeek= value

Read/Write at run time. Not available at design time.

Values

Description	Run Time
1 - First week	dbi1stInMonth
2 - Second week	dbi2ndInMonth
3 - Third week	dbi3rdInMonth
4 - Fourth week	dbi4thInMonth
5 - Fifth week	dbi5thInMonth
6 - Last week	dbiLastInMonth

Remarks

This property is often used with the EndWeekday property to specify the exact ending date, instead of the EndDay property.

This property takes effect only when the EndDay property is set to 0.

There are cases where, depending on months, the fourth/fifth and the last week refer to the same week. Also, when the number of the week specified does not exist in the month, the last week will be automatically retrieved. For example, in the year 1998:

' Add a new DSTStyle object

Set DSTS = objTZ.DSTStyles.Add(, "CN")

With DSTS

.EndMonth = dbiOctober

.EndDay = 0

.EndWeekday = dbiSunday

.EndWhichWeek = dbi5thWeek ' The fifth Sunday doesn't exist

End With

With this code, the ending date will refer to October 25th, 1998, which equals the fourth Sunday in October, since the fifth Sunday does not exist.