fiscalYear()
Returns the fiscal year number for a given date, based on your organization's configured fiscal year start month.
If no date is provided, the current context date is used.
When the fiscal year does not start in January, the fiscal year number is the calendar year in which the fiscal year ends. For example, with a February fiscal year start, February 2025 through January 2026 is fiscal year 2026.
Syntax
fiscalYear(date)
Parameters
Parameter | Type | Description |
|---|---|---|
date | DateDate | Optional. The date to get the fiscal year for. Defaults to today. |
Return Type
NumberNumber
The fiscal year number.
Examples
For an organization with a default fiscal year (starts in January):
fiscalYear('2025-05-12')
- Returns 2025.
For an organization with a fiscal year starting in February:
fiscalYear('2025-02-12')
- Returns 2026 because February 2025 is the start of fiscal year 2026 (ending January 2026).
fiscalYear('2025-01-12')
- Returns 2025 because January 2025 is the last month of fiscal year 2025.
Related Carrot
- fiscalYearStart()fiscalYearStart() - Returns the start date of the fiscal year
- fiscalYearEnd()fiscalYearEnd() - Returns the end date of the fiscal year
- fiscalQuarter()fiscalQuarter() - Returns the fiscal quarter number (1–4)
- year()year() - Returns the calendar year
