DOW( ) Function
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
Return Value
Numeric
Example
STORE DATE( ) TO gdDayNum
CLEAR
? DOW(gdDayNum)
? CDOW(gdDayNum)
See Also
Reference
CDOW( ) Function
DAY( ) Function
SET FDOW Command
SET FWEEK Command
SYS( ) Functions Overview
WEEK( ) Function