Returns a number representing the position in the week of the day part of a given date or date field. Sunday returns 1, Monday 2, etc.
DAYOFWEEK(date_field or date)
-
Date_field or date: The date to be processed or the name of a field containing one.
Example: Show the numeric value of the day in a given date.
DAYOFWEEK('16/02/1952)
Result: Returns 7 as that date was a Saturday
Example: For each Individual, show the numeric value of the day of their birth.
DAYOFWEEK([Individual.Date of Birth])
Result: Returns 1 for those born on Sunday, 2 for those born on Monday, etc.