Viewing post 1 (of 1 total)
Answer will be as below.
SET DATEFIRST 6GOSELECT FISCAL_DATE, DATEPART(WEEK,Fiscal_Date) FISCAL_WEEK FROM ERP.CUSTOM_FISCAL_CALENDER
SET DATEFIRST 6
GO
SELECT FISCAL_DATE, DATEPART(WEEK,Fiscal_Date) FISCAL_WEEK FROM ERP.CUSTOM_FISCAL_CALENDER
July 27, 2021 at 4:05 pm
#3914362