Function: IsoDayOfYear
Description
Returns the day number within the ISO8601 year on which the given date falls, using the ISO week-numbering year number. Note: The ISO week-numbering year can fall after the calendar year (for example, the 29th, 30th and 31st of December 2008 are all in week 1 of 2009) or before the calendar year (for example, the 1st, 2nd and 3rd of January 2010 are all in week 53 of 2009).
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 6/1/2008, the following expression would return 154: IsoDayOfYear([Ship Date])
Filter/Find example
Records with a Ship Date from 12/31/2007 to 5/31/2008 could be selected or found using the following filter expression: IsoDayOfYear([Ship Date])<154
© 2024 Altair Engineering Inc. All Rights Reserved.