Returns the day of the week for the date supplied.
WEEKDAY ( <date_field or date>, FORMAT)
-
date_field or date: The date field to use in the calculation.
-
format: Long or short representation of day.
-
0 = Short representation, e.g. MON
-
1 = Long representation, e.g. MONDAY
-
Example: Create a virtual field on the CUSTOMER table that returns the weekday that each customer was born on.
WEEKDAY( [CUSTOMER.DATE OF BIRTH] ,1)