Returns the day of the week, week number, or year of a Date Data Type.

Number := DATE2DWY(Date, What)



Type: Date

The input date.


Type: Integer

Specifies what the function returns. The valid options are 1, 2, and 3.

The value 1 corresponds to day of the week (1-7, Monday = 1).

The value 2 corresponds to week number (1-53).

The value 3 corresponds to year.

Expand imageProperty Value/Return Value

Expand imageRemarks

Expand imageExample

Expand imageSee Also