A= 11/1/2009-3/30/2010 B=4/1/2010-9/30/2010
What happened to October?
Ah, I see you have it under A here:
So try =
Case ( Mod ( Month ( Info_ReportingPeriod ) - 4 ; 12 ) > 5 ; "A" ; "B" )
Thank u very much Comment and yes I missed a one whole month here lol =) sorry 4that =)
and thank you for you great help!!