Project a Custom Fiscal Date Part

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

1SELECT 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
2FROM "OpportunityFiscalEMTimezoned"
3LIMIT 10;
CloseDate_Fiscal_YearCloseDate_Fiscal_QuarterCloseDate_Fiscal_MonthCloseDate_Fiscal_Week
201541149
201541149
201541249
201541253
201541254
2016115
2016129
2016129
20161313
20161313