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