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