Converting numbers to month name

[#1]

Hi,

Can some one help me in converting the numbers to month names?

I want to remove this number and just want to have the month names.

or is there any possibility to just change these numbers to month names.

Initially i used if statement to bring the month names. But i dont know how to replace the numbers with month names. Thank you.

[CELAMBARASAN]

Try this

=Month(Date(Date#([SPEND MONTH], 'YYYYMM MMM')))

Assuming that your field value is '201402 Feb', you will get Feb here.

[Peter_Cammaert]

What are you showing in your screenshot example in the OP? Is it a listbox?

[Peter_Cammaert]

How about:

=right([SPEND MONTH], 3)

[Anonymous]

Hi,

As your field contains data like "201401, 201402,..."

You can try in the script:

Table:

LOAD

     [SPEND MONTH],

     Month(Date#('01/'&right([SPEND MONTH],2)&'/'&left([SPEND MONTH],4),'DD/MM/YYYY')) as SpendMonth

FROM

File;

Then your field SpendMonth will contain the month name

[anbu1984]

Can you post sample app

[#7]

Hi Charen - probably a silly suggestion, so ignore if not applicable:  it almost sounds like you're looking for the right(datestring,2) (e.g. '201403' to yield 03), and then to applymap the numbers to a loaded mapping table, e.g. with 03,Mar or something to get the 'monthname' (?)