fiscalQuarter()
Returns the fiscal quarter number (1–4) 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.
Syntax
fiscalQuarter(date)
Parameters
Parameter | Type | Description |
|---|---|---|
date | DateDate | Optional. The date to get the fiscal quarter for. Defaults to today. |
Return Type
NumberNumber
A number from 1 to 4 representing the fiscal quarter.
Examples
For an organization with a default fiscal year (starts in January):
fiscalQuarter('2025-05-12')
- Returns 2 because May falls in Q2 (April–June).
For an organization with a fiscal year starting in February:
fiscalQuarter('2025-02-15')
- Returns 1 because February is the first month of the fiscal year, placing it in Q1.
fiscalQuarter('2025-01-15')
- Returns 4 because January falls in the last quarter of a Feb–Jan fiscal year.
Related Carrot
- fiscalQuarterStart()fiscalQuarterStart() - Returns the start date of the fiscal quarter
- fiscalQuarterEnd()fiscalQuarterEnd() - Returns the end date of the fiscal quarter
- fiscalYear()fiscalYear() - Returns the fiscal year number
- fiscalYearStart()fiscalYearStart() - Returns the start date of the fiscal year
