Function: IsoDayOfYear


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).




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.

Intellectual Property Rights Notice | Technical Support