4 Replies Latest reply: Dec 28, 2017 8:48 AM by Shahbaz Khan Mohammed 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





           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