Advertisement

create fiscal week number

fiscal sql sql-server

How can I put the below logic into a format SQL Server will use to create a fiscal week number ?

if (datepart(week,getdate())-4) <= 0  then (datepart(week,getdate())+49) else (datepart(week,getdate())-4)

​x
 
if (datepart(week,getdate())-4) <= 0  then (datepart(week,getdate())+49) else (datepart(week,getdate())-4)​

Advertisement

Answer

The CASE Statement should work:

CASE 
    WHEN (datepart(week,getdate())-4) <= 0
        THEN datepart(week,getdate())+49
    ELSE
        datepart(week,getdate())-4
END

 
CASE     WHEN (datepart(week,getdate())-4) <= 0        THEN datepart(week,getdate())+49    ELSE        datepart(week,getdate())-4END​

Advertisement