Retrieve the numeric representation of the weekday for a given date.
| SELECT Weekday(#05/17/2017#); |
The Weekday() function retrieves the weekday number corresponding to a given date, returning an integer between 1 and 7.
| Weekday(date, firstdayofweek) |
|
Parameter |
Description |
|
date |
Required. A date value that is considered valid. |
|
firstdayofweek |
Optional. Specifies the starting day of the week with the following options:
|
|
WORKS IN |
From Access 2000 |
Retrieve the weekday number corresponding to the current date.
| SELECT Weekday(Date()); |
Retrieve the weekday number for the specified date, with Monday set as the first day of the week.
| SELECT Weekday(#05/17/2017#, 2); |