Function: IsoWeek

Description

Returns the ISO8601 week number of the week in which the given date falls.

Syntax

IsoDayOfYear(date)

Arguments

date may be any valid date in the range 1/1/1601-12/31/2400.

Return value

This function returns a number.

Calculated field example

If the Ship Date field contained the date 4/18/2008, the following expression would return 16: IsoWeek([Ship Date])

Filter/Find example

Orders shipped during the first 12 ISO weeks of 2008 can be returned or found using the following expression: IsoWeek([Ship Date])<13