---
schema_version: "1"
id: 9fadfe72775ac2289fafe543c428e79a4c3d5f17dd5d8dad8201961d74182fe2
title: end_of_fiscal_quarter
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_function_ref_end_of_fiscal_quarter.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_end_of_fiscal_quarter.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: fb8f49a9a5af77f9ef41534209c6a31ddf5f753b9958cc636acc107b6a0c62e1
description: Returns the last day of the fiscal quarter for a specific date or time in Salesforce Spiff. The return format is YYYY-MM-DD. If you haven't specified fiscal year dates in Spiff, this function falls back to a standard calendar year.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# end\_of\_fiscal\_quarter

Returns the last day of the fiscal quarter for a specific date or time in Salesforce Spiff. The return format is YYYY-MM-DD. If you haven't specified fiscal year dates in Spiff, this function falls back to a standard calendar year.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

## Syntax

```
end_of_fiscal_quarter(date or time, offset)
```

## Arguments

  
| Argument | Required? | Description |
| --- | --- | --- |
| date\_or\_time | Required | The Date or Date & Time value to evaluate. This argument supports any date functions. |
| offset | Optional | An integer that overrides the end of the fiscal quarter by one month. Positive values shift the end forward in time and negative values shift the end back in time. |

## Example

Return the end of the fiscal quarter based on the end of the statement period, using the EndOfPeriod helper function, and adjust the value by one month back in time.

```
=end_of_fiscal_quarter(EndOfPeriod, -1)
```

#### See Also

- [Year, Quarter, or Month Functions](https://help.salesforce.com/s/articleView?id=sales.spiff_functions_date_period.htm&release=264.0.0&type=5 "Functions for the beginning and end of a year, quarter, or month in Salesforce Spiff help you compare data during the specified time period. Combine these functions with other functions that process dates.")
- [Helper Functions in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_functions_helper.htm&release=264.0.0&type=5 "Helper functions in Salesforce Spiff save time and provide clarity. A helper function is interchangeable with a standard function, but uses simpler syntax so you can create logic more easily.")