Sdílet prostřednictvím


DAYOFWEEK (Report Builder 1.0)

Returns the day of the week, starting with Monday. Monday = 1 through Sunday = 7.

Syntax

DAYOFWEEK(datetime)

datetime

Specifies the datetime from which the day of the week is extracted.

Example

Formula

Result

DAYOFWEEK(#4/3/2009#)

5

DAYOFWEEK(Sell Start Date)

Returns a day of the week for each instance of the Sell Start Date field similar to the following:

1

2

7