In Access, the Weekday function returns an integer between 1 (Sunday) and 7 (Saturday) that represents the day of the week corresponding to the date and the first day of the week provided as arguments.
The syntax for the Weekday function is:
Weekday ( date, [firstdayofweek] )
The argument date is any numeric expression that can represent a date and/or time. Numbers to the left of the decimal point in date represent the date; numbers to the right represent the time. If date is Null, this function returns a Null. The firstweekday argument is an optional integer argument that specifies the first day of the week. The following is a list of valid parameters for firstweekday.
|vbUseSystem||0||Use the NLS API settings|
|vbSunday||1||Sunday (default used)|
This example uses the Weekday function to obtain the day of the week from a specified date. Now the MyWeekday variable would contain the value of 4.
You can also use the Weekday function in a query.