Month Name from Month Number

[john_s_w_wood]

Has anyone got a slick way of converting a month number to a month name?

I either end up using an inline table ( generally as a mapping / applymap)

1,Jan

2,Feb 

etc

or a horrible string function pick(monthno, 'Jan', 'Feb', etc)

Thanks

[petter]

You can use this:

=SubField(MonthNames,';',1)

1 gives Jan ... and so forth...

MonthNames should be predefined according to your settings in Windows and at the top of your load script.

So in your case it should be:

  =SubField(MonthNames,';',monthno)

[tresesco]

Month(MakeDate(1,MonthNum))

[Anonymous]

best way is to do a inline mapping table load and use applymap

Thanks

BKC

[antoniotiman]

Month(Date#(4,'MM'))

[Gabriel]

Hi,

Try this script

load
Month(MakeDate(Today(), MonthNumber, 1)) AS Month_Name,
* Inline [

MonthNumber
1
2
3
4
5
6
7
8
9
];

 

[john_s_w_wood]

Thanks Folks - All great answers

[luizcdepaula]

This worked perfectly for me. Thanks.