how to convert month number into month name

[Karim_Khan]

RIGHT([Fiscal Period ID],2) AS Month is showing month like 1,2,3,4,5,6,7,8,9 need to convert into Jan,Feb Mar,Apr

[awhitfield]

Hi Karim,

what's the format of the data in the [Fiscal Period ID]?

Andy

[#3]

Use Month(YourDateField)..

i.e Month(RIGHT([Fiscal Period ID],2) ) as Month.

[Karim_Khan]

201506

[#5]

Try this

=Date(Date#(RIGHT([Fiscal Period ID],2) ,'YYYYMM'),'MMM')

[maxgro]

try with

=SubField(MonthNames,';',  RIGHT([Fiscal Period ID],2))

or

=month(date#(RIGHT([Fiscal Period ID],2), 'MM'))

[qlikmsg4u]

=Month(Date#(Right(201506,2), 'MM'))

[MK_QSL]

SubField('$(MonthNames)',';',RIGHT([Fiscal Period ID],2))

[#9]

match(RIGHT([Fiscal Period ID],2), 'Jan' , 'Feb' , 'March' , 'April' , ' May' , 'June' ,'July' , 'Aug' , ' Sep' , 'Oct' , ' Nov' , 'Dec')

[awhitfield]

HI Karim,

based on the format supplied, please try the following:

FPID:
Load * Inline
[
"Fiscal Period ID"
201501
201502
201503
201504
201505
201506
201507
201508
201509
201510
201511
201512
];

Month:

Load
month(date#(RIGHT([Fiscal Period ID],2), 'MM'))  // THIS IS THE SECTION YOU NEED


Resident FPID;

HTH - Andy