Share via


WEEK (Report Builder 1.0)

Returns the numeric value for the week within the calendar year.

Syntax

WEEK(datetime)

datetime

Specifies the datetime from which the week (1-52) is extracted.

Example

Formula

Result

WEEK(Sell Start Date)

Returns the numeric value of the sales week for each instance of the Sell Start Date field, similar to the following:

25

50

WEEK(#7/22/2009#)

30