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.

[tresesco]

Try like:

Month(MakeDate(1,MonthNum)) as Month

[its_anandrjs]

Provide sample file or may be you can try MonthName( DateField ) if you have any date field in the data model.

Regards

Anand

[#4]

Hi,

Sorry its not working out. Any other suggestions?

Thank you.

[its_anandrjs]

You can try this also in load script

Num( Month( Date( DateField,'YYYYMM' ) )) as NumMonth

Or

Num( Month(DateField) ) as NumMonth

Ex:-

=Num( Month( Date( Today(),'YYYYMM' ) ))

Regards

Anand

[#6]

Hi,

This is the actual field

Here i need to change the numbers into months .

Thank you.

[tresesco]

Try like:

Month(MakeDate(1,Mid([SPEND MONTH],5))) as Month

[its_anandrjs]

Try

Num( Month( Date( [SPEND MONTH],'YYYYMM' ) ) ) as NumMonth

Or

Num( Month( [SPEND MONTH] ) ) as NumMonth

Regards

Anand

[Peter_Cammaert]

Try

Month(MakeDate(1,num(right([SPEND MONTH], 2)))) as Month

[its_anandrjs]

I added and update the tresesco expression as

Month(MakeDate(1,Mid([SPEND MONTH],5,2))) as Month

Or

Month(MakeDate(1,right([SPEND DATE], 2))) as Month

Regards

Anand