Convert months (numeric) into text

[#1]

Hi Experts

I have a file that contains months in a numeric format. How can I convert the numeric values into text for the months? (Jan, Feb, e.g.)

Thank you for your help!

Jan

[hariprasadqv]

Hi,

use dual function or MMM format with date.

[hic]

If you want your month names automatically sorted - i.e. as dual values - you should use the solution suggested by Robert_Mika:

     Month(MakeDate(2015,MonthNumber))

Month names created with Text() will be sorted alphabetically, which you don't want.

An inline table will work, but this demands an additional table, when you really want to convert month numbers to month names when loading another table, i.e. inside another Load statement.

HIC