MS Access Weekday() 函数

返回日期的工作日编号：

SELECT Weekday(#05/17/2017#);

定义和用法

Weekday() 函数返回给定日期的工作日数。

该函数返回 1 到 7 之间的整数。

Weekday( date, firstdayofweek)

Parameter	Description
date	Required. A valid date
firstdayofweek	Optional. Specifies the first day of the week. Can be one of the following values: 0 = Use the NLS API setting 1 = Sunday (default) 2 = Monday 3 = Tuesday 4 = Wednesday 5 = Thursday 6 = Friday 7 = Saturday

工作于：	从 Access 2000