FISCAL_WEEK from 1 Jan till First Friday

• birajdarmm@gmail.com

  SSC Rookie

  Points: 35

  More actions

  July 27, 2021 at 2:32 pm

  Go to Answer

  #3914324

  Hi,

  We have one requirement. Wee need to create a fiscal_week column in SQL_server table.

  Table will have data as Normal_date column as fiscal_date and fiscal_year colum which will have year part of the date.

  Logic for FISCAL_WEEK is as below.

  - FIRST FISCAL WEEK WILL START FROM 1 JAN OF EVERY YEAR AND IT WILL BE TILL FIRST FRIDAY.

  - SECOND WEEK STARTS FROM SATURDAY AND IT WILL RUN TILL NEXT FRIDAY.

  - THIS WILL GO ON TILL THE END OF YEAR (31 JAN)

  We will Have data something as below table.

  

  How would I create query for this ? We will have data from 2010 till 2035 years in the table.

  Thanks,

  Mahesh

• birajdarmm@gmail.com

  SSC Rookie

  Points: 35

  More actions

  July 27, 2021 at 4:05 pm

  Answer

  #3914362

  Answer will be as below.

  SET DATEFIRST 6

  GO

  SELECT FISCAL_DATE, DATEPART(WEEK,Fiscal_Date) FISCAL_WEEK FROM ERP.CUSTOM_FISCAL_CALENDER