---
schema_version: "1"
id: 2a2111bda60a67f2104d5a4d5a1d8d7e01281d76926fda1d184314008b59d829
title: Project a Custom Fiscal Date Part
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-date-cfy.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-date-cfy.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 7747b446b5ddd995758dffa330309ab06d8485d424e2b96c6dd687d4fa3120af
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# Project a Custom Fiscal Date Part

To project a custom fiscal date part, pass custom fiscal date parts to the `EXTRACT()` function.

```nolang
SELECT EXTRACT(FISCAL_YEAR FROM CloseDate) AS CloseDate_Fiscal_Year, EXTRACT(FISCAL_QUARTER FROM CloseDate) AS CloseDate_Fiscal_Quarter, EXTRACT(FISCAL_MONTH FROM CloseDate) AS CloseDate_Fiscal_Month, EXTRACT(FISCAL_WEEK FROM CloseDate) AS CloseDate_Fiscal_Week
FROM "OpportunityFiscalEMTimezoned"
LIMIT 10;
```

| CloseDate_Fiscal_Year | CloseDate_Fiscal_Quarter | CloseDate_Fiscal_Month | CloseDate_Fiscal_Week |
| --------------------- | ------------------------ | ---------------------- | --------------------- |
| 2015                  | 4                        | 11                     | 49                    |
| 2015                  | 4                        | 11                     | 49                    |
| 2015                  | 4                        | 12                     | 49                    |
| 2015                  | 4                        | 12                     | 53                    |
| 2015                  | 4                        | 12                     | 54                    |
| 2016                  | 1                        | 1                      | 5                     |
| 2016                  | 1                        | 2                      | 9                     |
| 2016                  | 1                        | 2                      | 9                     |
| 2016                  | 1                        | 3                      | 13                    |
| 2016                  | 1                        | 3                      | 13                    |