How to convert Month numbers "01" to "January"

[Anonymous]

Dear Qlik,

I want to show month numbers into full month names like 01 to January.

please give me a suggestion on my task. I attached sample excel file  and in that i want to show output.

[dplr-rn]

Modify your environment variables and use month function. like below

SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

Load *,

Month(Date) as month;

LOAD Date

FROM

[.\Dates.xlsx]

(ooxml, embedded labels, table is Sheet1);

[avkeep01 · Accepted solution]

Hi Suman,

Try DATE(MONTHSTART([DateField]),'MMMM') AS Month

You can adjust the system variable (at the beginnen of your script)

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

[Anonymous]

Dear Dilip,

I am using same method .

Thanks for quick response to giving suggestion on my task.

Regards

Suman

[dplr-rn]

no problem. Close thread as answered if it helped

[Anonymous]

Dear Anton,

Iam trying with your expression, it's exactly working what i want to show.

Thanks for giving good suggestion.

Regards

Suman