Project a Custom Fiscal Date Part
To project a custom fiscal date part, pass custom fiscal date parts to the EXTRACT() function.
| 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 |