WEEKDAY

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

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: create a virtual field on the CUSTOMER table that returns the weekday that each customer was born on.

WEEKDAY( [CUSTOMER.DATE OF BIRTH] ,1)