Skip to Content
0
Dec 02, 2013 at 03:32 PM

Use month name in XL Reporter

15 Views

Hi everyone, im trying to get the month name in XL reporter with this

1) =MONTH(RIGHT(ixDimGet("PER", "PeriodInYear"))) in cell A1

Format cell A1 - Custom Type MMM

and it works great, the thing is that '201401' is not january but october in the customers system, Fiscal Year is 10-01-13/09-30-14

im trying to do it like this (ixDimGet("PER", "PeriodInYear")+9) and it shows a 10 but wont script it as Oct.

Thanx in advance