DOW( )
Topic group Related topics Example
Returns the day of the week corresponding to a specified date as a number from 1 to 7.
Syntax
DOW(<expD>)
<expD>
The date whose corresponding weekday number you want to return.
Description
DOW( ) returns the number of the day of the week on which a date falls:
|
Day |
Number |
|
Sunday |
1 |
|
Monday |
2 |
|
Tuesday |
3 |
|
Wednesday |
4 |
|
Thursday |
5 |
|
Friday |
6 |
|
Saturday |
7 |
To return the name of the day of the week instead of the number, use CDOW( ). DOW( ) returns zero for a blank date.