Function: IsoYear

Description

Returns the year corresponding to the ISO8601 week in which the given date falls. Note: For dates near the end of December or the start of January this may be different than the calendar year.

Syntax

IsoYear(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 a date of 12/30/2007 the following expression would return 2007: IsoYear([Ship Date])

Filter/Find example

The following filter expression would select or return only those records whose Ship Date values occur in 2008: IsoYear([Ship Date])=2008