Access - The Weekday function

December 2016



Description


This funtion returns a number representing the nth day of a week, based on a date.

Syntax


Weekday(date, first_day_of_week)
  • Where date: can be either represented as a numerical or string expression.
  • And first_day_of_week: Is a constant that will represent the first day of the week.


The possible value of "first_day_of_week":

vbUseSystem	0	Use the National Language Support API setting.
vbSunday	1	Sunday (if constant is omitted, value used by default)
vbMonday	2	Monday
vbTuesday	3	Tuesday
vbWednesday	4	Wednesday
vbThursday	5	Thursday
vbFriday	6	Friday
vbSaturday	7	Saturday

Related :

This document entitled « Access - The Weekday function » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.