Function: IsoYear


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.




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





© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support