This content has been marked as final. Show 4 replies
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