10 Replies Latest reply: Jan 5, 2016 4:34 PM by Mark Graham RSS

    Need to calculate first Monday in February for fiscal calendar

    Mark Graham

      Hello Everyone,


      I'm trying to create a master calendar with fiscal weeks and year.

      My fiscal week should start from First Monday of February as Fiscal Week 1.



      So, i wanna automate something which should not change with respect to year.

      Any help is highly appreciated!

      I tried the following, but no luck. It changes year by year.

      if(week(TempDate) > 5,week(TempDate)-5, week(TempDate) + 47) As [Fiscal Week],


      if((week(TempDate) < 5), (year(TempDate)-1), year(TempDate)) as [Fiscal Year],