How to convert Month Year Formate YYYY_MM into MMM-YYYY ?

[#1]

Hi,

I am new to qlikview.

I have Month and Year in below formate.

2014_01

i would like to convert and show thisin below format using LOAD Statement.

Jan-2014

any help would be greatly appreciated.

[#2]

Hi,

Add the below within your load statement:

Load YourDateField,

date(date#(YourDateField, 'YYYY_MM'), 'MMM-YYYY') as dte2

from ...

[#3]

Great!.

it works.

[#4]

Glad to help Hailey

Kindly mark the answer as correct to close the thread.

Thx.