WEEK

Returns the week number of the year (1-52) in which a date falls as a number, allowing transactions to be grouped and reported on by fiscal week number.

WEEK ( <date_field or date> )

date_field or date: The date field to use in the calculation.

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 field on the ORDER table that returns the week number of the year in which the order date falls.

WEEK([ORDER.ORDER DATE])