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
© 2024 Altair Engineering Inc. All Rights Reserved.