DAYOFWEEK

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.

Note: dates in Audiences need to be formatted as either YYYY-MM-DD or MM/DD/YYYY. Entering a date as 01-02-2023 would be read as Jan-2 not 1-Feb.

Example: show the numeric value of the day in a given date.

DAYOFWEEK('12/02/1952)

Result: Returns 3 as that date was a Tuesday.

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.