Week()

Convert a date value to the week number of the year.

Syntax

Week (<dDate>) --> nWeek

Arguments

<dDate> --> is the date value to convert.

Returns

Week () returns a number between 0 and 52. Specifying a null date (CTOD("")) returns zero.

Description

Week () is a date conversion function that is useful when you require a numeric week value during calculations for such things as periodic reports. See also Day() and Year() which return the number of the day of the week and the day of the year respectively. The function Month() returns the number of the month from a date value.

____________________________