DayOfWeek(Date date)
Returns the number of days by which the given date follows the first day of the week (Sunday returns 0).
Parameters
- date
- The date to check.
Returns
Numeric
| Day of the Week | Return Value |
|---|---|
| Sunday | 0 |
| Monday | 1 |
| Tuesday | 2 |
| Wednesday | 3 |
| Thursday | 4 |
| Friday | 5 |
| Saturday | 6 |
Remarks
If the date value is null, the system returns the numeric value 0.
Examples
DayOfWeek(#2013-03-21#)returns the numeric value 4, indicating Thursday.DayOfWeek(#2013-03-24#)returns the numeric value 0, indicating Sunday.