4 Replies Latest reply: Dec 28, 2017 8:48 AM by S Khan RSS

    FY Calendar , how to get Week 1,2,3,4.. in every month?

    gaurav gopale

      Hi all

       

      I have a FY Calendar , in which i have create following field

       

      if(

           Weekstart(Date,0,0)=weekstart(yearstart(Date,1,4),0,0),

           1,

           Div(Date-YearStart(Date,0,4) + WeekDay(YearStart(Date,0,4),0) +7,7)

      )  as FiscalWeek

       

      which gives me FY week  like 1,2,3,4,5,.......53

       

      But my requirement is for every month their should be W1,W2,W3,W4 ,W5 for every month .

       

      can anyone help me in this

       

       

      Thanks in advance