Use month name in XL Reporter

[leonardoe_martinez]

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

[julie_jamieson2 · Accepted solution]

Why not use the period field T_RefDate (or F_RefDate) - in XLR I think these are period End 2 & PeriodStart 2 which give you a date field you can format with standard Excel formula?

[leonardoe_martinez · Accepted solution]

Genius!! thank you very much

This is what i did:

=DATE(LEFT(ixDimGet("PER", "PeriodStart"),4),LEFT(RIGHT(ixDimGet("PER", "PeriodStart"),4),2),RIGHT(ixDimGet("PER", "PeriodStart"),2))

Then format as mmm.

[kothandaraman_nagarajan]

Hi,

To get month, you can try with datename function.

datename(mm,T0.[DocDate]) as month

Thanks & Regards,

Nagarajan

[leonardoe_martinez]

Are you aware this is for "XL Reporter"? not sql querys

[kothandaraman_nagarajan]

Hi,

Sorry. Not familiar with XL report.

Thanks & Regards,

Nagarajan