fiscalQuarterEnd()
Returns the last date of the fiscal quarter 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
fiscalQuarterEnd(date)
Parameters
Parameter | Type | Description |
|---|---|---|
date | DateDate | Optional. The date to calculate the fiscal quarter end from. Defaults to today. Accepts hardcoded dates (e.g. '2025-05-01') or Relative Datesrelative date offsets (e.g. '+3m', '-3m'). |
Return Type
DateDate
The last day of the fiscal quarter that contains the given date.
Examples
For an organization with a default fiscal year (starts in January):
fiscalQuarterEnd('2025-05-12')
- Returns 2025-06-30 because May 12 falls in Q2, which ends on June 30.
For an organization with a fiscal year starting in February:
fiscalQuarterEnd('2025-02-15')
- Returns 2025-04-30 because February falls in fiscal Q1, which ends on April 30.
fiscalQuarterEnd('2025-01-15')
- Returns 2025-01-31 because January falls in fiscal Q4, which ends on January 31.
Using Relative Date Offsets
Relative date offsets can be passed to resolve dynamically relative to today, without needing to hardcode a specific date:
fiscalQuarterEnd('+3m')
- Returns the end of the fiscal quarter that is 3 months from today (i.e. "next quarter" when called during the first month of the current quarter).
fiscalQuarterEnd('-3m')
- Returns the end of the fiscal quarter that is 3 months ago (i.e. "last quarter").
This is especially useful for dynamic date filters in reports and dashboards. For example:
closeDate >= fiscalQuarterStart('+3m') and closeDate <= fiscalQuarterEnd('+3m')This expression will always refer to next quarter's date range without needing manual updates.
Related Carrot
- fiscalQuarterStart()fiscalQuarterStart() - Returns the start date of the fiscal quarter
- fiscalQuarter()fiscalQuarter() - Returns the fiscal quarter number (1–4)
- fiscalYearEnd()fiscalYearEnd() - Returns the end date of the fiscal year
- Relative DatesRelative Dates - Relative date expressions supported in CQL
