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