---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/fiscal-calendar-options.md
cuppy_section: docs
cuppy_doc: GBYQ-7Q42
cuppy_doc_uuid: 791aac0f-b73d-4da0-9dc7-b4f14ed55bd3
cuppy_permalink: https://cuppy.io/salesforce/d/GBYQ-7Q42
cuppy_version: 1
cuppy_updated: 2026-10-23T16:16:52.575Z
cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/fiscal-calendar-options
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: 2027e4a4fc9df862083c52adcaa4c9827b7487e87f41807402715274b10503a3
# cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks.
---

> Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/fiscal-calendar-options.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

## Fiscal Calendar Options

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Fiscal calendar options configure standard or custom fiscal years in a query. A fiscal calendar can differ from the standard calendar to match your business needs.

You can use fiscal calendar options in the [`EXTRACT` and `date_part`](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/extract.html), [`DATE_TRUNC`](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/date-trunc.html), [`DATEDIFF`](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/datediff.html), [`DATE_ADD`](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/date-add.html), and [`TO_CHAR`](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/to-char.html) functions when the field is a fiscal date unit:

*   `fiscal_year_start_month => <value>`: The first month of your fiscal year. Default: `1` (January). For example, if the fiscal year starts in February, `<value>` is `2`.

*   `first_day_of_fiscal_week => <value>`: The first day of your fiscal week. Default: `1` (Monday). For example, if the fiscal year starts in January and `<value>` is `1` (Monday), `fiscal_week` for the date `2023-01-02` returns `2`, because `2023-01-01` is a Sunday, making `2023-01-02` the second week of the fiscal year.

*   `use_start_date_as_fiscal_year_name => <value>`: Sets the naming of your fiscal year to the current year or the next year. Default: `true`. For example, the fiscal year starting at `2020-04-01` is 2020 if `<value>` is `true`. If `<value>` is `false`, the fiscal year is 2021.

*   `fiscal_period_table => TABLE(<table_expression>)`: Uses a custom fiscal calendar that you define in a `<table_expression>`. The `<table_expression>` is a lookup table that maps each day to its fiscal periods. It has these columns:

*   You can’t combine standard and custom fiscal calendar options.
*   In Data 360, functions use the fiscal calendar configured in your org by default. If you haven’t configured a calendar, the function uses a standard fiscal calendar with the default values.

Returns `2`.

Returns `1999`.

Returns `2001`.

Returns `1`.

*   [EXTRACT and date_part](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/extract.html)
*   [DATE_TRUNC](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/date-trunc.html)
*   [DATEDIFF](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/datediff.html)
*   [DATE_ADD](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/date-add.html)
*   [TO_CHAR](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/to-char.html)
*   [Localized Week Options](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/localized-week-options.html)
*   [Date/Time Functions and Operators](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/datetime-func.html)


---
<!-- cuppy -->
You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.
<!-- /cuppy -->