fiscalQuarterStart()
Returns the start 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
fiscalQuarterStart(date)
Parameters
Parameter | Type | Description |
|---|---|---|
date | DateDate | Optional. The date to calculate the fiscal quarter start 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 first day of the fiscal quarter that contains the given date.
Examples
For an organization with a default fiscal year (starts in January):
fiscalQuarterStart('2025-05-12')
- Returns 2025-04-01 because May 12 falls in Q2, which starts on April 1.
For an organization with a fiscal year starting in February:
fiscalQuarterStart('2025-03-15')
- Returns 2025-02-01 because March falls in fiscal Q1, which starts on February 1.
fiscalQuarterStart('2025-01-15')
- Returns 2024-11-01 because January falls in fiscal Q4, which started on November 1 of the previous calendar year.
Using Relative Date Offsets
Relative date offsets can be passed to resolve dynamically relative to today, without needing to hardcode a specific date:
fiscalQuarterStart('+3m')
- Returns the start of the fiscal quarter that is 3 months from today (i.e. "next quarter" when called during the first month of the current quarter).
fiscalQuarterStart('-3m')
- Returns the start 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
- fiscalQuarterEnd()fiscalQuarterEnd() - Returns the end date of the fiscal quarter
- fiscalQuarter()fiscalQuarter() - Returns the fiscal quarter number (1–4)
- fiscalYearStart()fiscalYearStart() - Returns the start date of the fiscal year
- Relative DatesRelative Dates - Relative date expressions supported in CQL
