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