• Contents
  • Index

Altair® Monarch®

 

FiscalDayOfYear Function

Description

Returns the day number within the fiscal year in which the given date falls.

Syntax

FiscalDayOfYear(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

The following expression will return 45 from a Ship Date field containing 2/14/2008: FiscalDayOfYear([Ship Date])

Filter/find example

Orders shipped in the first month of 2008 could be found with the following expression: FiscalDayOfYear([Ship Date])<32

Note: The example above assumes that the following time intervals settings have been specified via the Time Intervals wizard:

  • The fiscal year consists of 12 calendar months starting on January 1.

  • The fiscal week is defined as the first week of the year that starts on January 1, regardless of what day of the week it is.

  • The calendar week is defined as the first week of the year that starts on January 1, regardless of what day of the week it is.