Returns a numeric day-of-the-week value from a Date or DateTime expression.

DOW(dExpression | tExpression [, nFirstDayOfWeek])

Parameters

dExpression

Specifies the Date expression from which DOW( ) returns the day number.

tExpression

Specifies the DateTime expression from which DOW( ) returns the day number.

nFirstDayOfWeek

Specifies the first day of the week. nFirstDayOfWeek may be one of the following values.

nFirstDayOfWeek Description

0

DOW( ) uses whatever day is currently selected in the Week Starts On list box, which appears on the Regional Tab in the Options dialog box.

1

Sunday. This is the default when nFirstDayOfWeek is omitted, and is the first day of the week used in earlier FoxPro versions.

2

Monday

3

Tuesday

4

Wednesday

5

Thursday

6

Friday

7

Saturday

Expand imageReturn Value

Expand imageExample

Expand imageSee Also