---
schema_version: "1"
id: d2529699a882642b47c10b7f7722796950c619ab19a1fe467d7d6f2a9d0c8181
title: Work with Custom Fiscal Year Data
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/reference/bi-saql-cfy.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-cfy.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 10965cb4b51b262ea2f427849a41b383a78b0bf153fafb5421a9b80570c111d7
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# Work with Custom Fiscal Year Data

After inheriting custom fiscal years, SAQL queries support custom fiscal year data.

Analytics supports custom fiscal year data by generating new fields that describe the custom fiscal year. Each of these new fields is named with the `_Fiscal` suffix. By working with these fields, SAQL supports custom fiscal year data.

Make sure that a dataset’s dataflow has run after inheriting custom fiscal years and before writing SAQL based on custom fiscal year data.

Each of the queries in the examples is based off the following dataset. These examples presume that Analytics inherited custom fiscal years that begin on February 1 and end on January 31. Custom fiscal years are defined from 2017 until 2022.

**note:** You can’t use custom fiscal year data with the fill or timeseries statements.

| Opportunity Name | Created Date | Amount |
| ---------------- | ------------ | ------ |
| Widgets          | 2/15/2017    | 100    |
| Widgets          | 1/25/2018    | 200    |
| Widgets          | 3/30/2018    | 100    |
| Widgets          | 3/30/2019    | 100    |
| Widgets          | 3/30/2020    | 100    |
| Widgets          | 3/30/2021    | 100    |
| Widgets          | 3/30/2022    | 100    |

- **[Group by a Custom Fiscal Year](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-cfy-group.md)**


    Here’s how to group by a custom fiscal year.

- **[Filter by a Custom Fiscal Year](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-cfy-filter.md)**


    Here’s how to filter by a custom fiscal year date.

- **[Dates Outside Ranges Defined by Custom Fiscal Year](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-cfy-ranges.md)**


    If your query includes a date that falls outside of a range defined by an inherited fiscal year, SAQL does not return data for that date.

**See Also**

- [Date Formats and Fiscal Dates for Source Data](https://help.salesforce.com/s/articleView?id=bi_integrate_date_formats_and_fiscal_dates.htm)