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.
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])