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, DATE_TRUNC, DATEDIFF, DATE_ADD, and TO_CHAR 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.