ComponentOne True DBInput Pro 8.0
WeekPattern Property (TDBDateX)

 

Reference> TDBDateX Object> TDBDateX Object Properties> WeekPattern Property (TDBDateX)

WeekPattern Property (TDBDateX)

The WeekPattern property determines how a week should be treated when executing calculations using the TotalWeeks, WeekInfo methods.

Syntax

object.WeekPattern= value

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

Values

Description

Run Time

0 - Row pattern (Default)

dbiRow

1 - Full week pattern

dbiFullWeek

Remarks

The weeks you retrieve will be controlled by the setting of the StartOfWeek property which determines the first starting weekday of the week.

If set to 0-Row pattern (the default), every row in the calendar is counted as one week, even if only one day exist in a row. But note when a week crosses over multiple months, it is treated as a single week. For example, April, 1998 through May will return 10 weeks when StartOfWeek is set to 1-Sunday(default).

However, if set to 1-Full week pattern, every full week will be counted as one week (the remaining days can be included or exclude depending on the option set in the TotalWeeks method). When the remaining days are included, 9 weeks will be returned and 8 weeks when the days are excluded in the case above.

By default, the start of weekday will be picked up from the system.

See Also

TotalWeeks Method (TDBDateX)

WeekInfo Method (TDBDateX)

StartOfWeek Property (TDBDateX)

 

 


Copyright (c) GrapeCity, inc. All rights reserved.

Product Support Forum  |  Documentation Feedback