---
title: fiscalQuarterEnd()
slug: fiscalquarterend
docTags: 
createdAt: 2026-02-09T14:47:06.874Z
---

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`        | **[Date](docId\:xTAQdzvLBTAKjxRnpFwe9)** | Optional. The date to calculate the fiscal quarter end from. Defaults to today. Accepts hardcoded dates (e.g. `'2025-05-01'`) or **[Relative Dates](docId\:LVlFv-1A-ePBySJQJ5FJC)** (e.g. `'+3m'`, `'-3m'`). |

### Return Type

**[Date](docId\:xTAQdzvLBTAKjxRnpFwe9)**

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:

```javascript
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()](docId\:iUPfFY8zADBoxeNN_JmvG)** - Returns the start date of the fiscal quarter
- **[fiscalQuarter()](docId\:usyc-tk0V_bMTgUHK9eiB)** - Returns the fiscal quarter number (1–4)
- **[fiscalYearEnd()](docId\:jGCeF8TWW3ZsK3FvgDqMt)** - Returns the end date of the fiscal year
- **[Relative Dates](docId\:LVlFv-1A-ePBySJQJ5FJC)** - Relative date expressions supported in CQL