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],