Skip to main content
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert months (numeric) into text

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!


11 Replies
Creator III
Creator III


use dual function or MMM format with date.

Former Employee
Former Employee

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


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.