1. Weekday() Function :
In MS Access, The weekday() function returns the weekday number for a given date. In this function, a date will be passed as a parameter and it returns the weekday of that date. By default the 1 is denoted for Sunday and 7 for Saturday. The second parameter will be optional it will be the first day of the week.
Syntax :
Weekday(date, firstdayofweek)
Parameters Value :
| Parameter | Description |
|---|---|
| date | It is required. A valid date. |
| firstdayofweek |
optional, it will specifies the first day of the week 0 : For NLS API setting 1 : Sunday (default) 2 : Monday 3 : Tuesday 4 : Wednesday 5 : Thursday 6 : Friday 7 : Saturday |
Example-1 :
SELECT Weekday(#06/17/2020#);
Output :
4
Example-2 :
SELECT Weekday(Date());
Output :
5
2. WeekdayName() Function :
In MS Access, the WeekdayName() function returns the weekday name. In this function, the first function will be the week number and the second parameter will be abbreviate.it is optional. If you want abbreviation then pass true otherwise pass false. and the third parameter will be the first day of the week. It is also optional.
Syntax :
WeekdayName(number, abbreviate, firstdayofweek)
Parameters :
| Parameter | Description |
|---|---|
| number | It is required. It will be in the range of 1 to 7 |
| abbreviate | Optional.For abbreviation true otherwise false |
| firstdayofweek |
optional, it will specifies the first day of the week 0 : For NLS API setting 1 : Sunday (default) 2 : Monday 3 : Tuesday 4 : Wednesday 5 : Thursday 6 : Friday 7 : Saturday |
Example-1 :
SELECT WeekdayName(1);
Output :
Sunday
Example-2 :
SELECT WeekdayName (3, TRUE, 2)
Output :
Wed