Function: FiscalYear
Description
Returns the year number of the fiscal year in which the given date falls. If at_start is 0 or not given, then the fiscal year is numbered for the calendar year in which it ends. If at_start is non-zero, then the fiscal year is numbered for the calendar year in which it starts.
Syntax
FiscalYear(date,[at_start])
Arguments
Date may be any valid date in the range 1/1/1601-12/31/2400. At_start is a number (0 or 1) that specifies whether the fiscal year is numbered for the calendar year in which it ends (0) or for the calendar year in which it starts (1).
Return Value
This function returns a number.
Calculated field example
If the Ship Date field contained 1/8/2008, the following expression would return 2008: FiscalYear([Ship Date],0)
Note: If the expression was modified to FiscalYear([Ship Date],1), 2007 would be returned.
Filter/find example
The following expression would select or find all the records in which the ship date falls within the 2008 fiscal year: FiscalYear([Ship Date],0)=2008
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.
© 2024 Altair Engineering Inc. All Rights Reserved.