how to change month in number to name format

[#1]

Hi

The data for field "month" is in number format, how can i change it as Jan,Feb,Mar,Apr,May...Dec?

Thanks

[robert_mika]

month(MakeDate(2000,yourfield,1)) as MonthName

[Anil_Babu_Samineni]

Can you provide the script?

Pick(Match(Month,'1','2','3','4','5','6','7','8','9','10','11','12'),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

OR

Use SET Environment of

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

Instead of

SET MonthNames='1;2;3;4;5;6;7;8;9;10;11;12';

OR Final table seems This.

LOAD Pick(Match(Month,'1','2','3','4','5','6','7','8','9','10','11','12'),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec') as Month;

Load * Inline [

Month

1

2

3

4

5

6

7

8

9

10

11

12

];

[MarcoWedel]

Month(Date#(Month,'M'))

hope this helps

regards

Marco