WEEKNUM
Returns a number representing the week of the year where the provided date falls
Usage examples
-
WEEKNUM("1/5/2010") -
WEEKNUM(tableA.fieldB)
Syntax
WEEKNUM ( date_serial_num, [ return_type ] )
-
date_serial_num- the date for which to determine the week number -
return_type- a number representing the day that a week starts on as well as the system used for determining the first week of the year (1=Sunday, 2=Monday)
Returns
number - the number representing the week of the year.