Date Conversion

[#1]

Hi All,

           I am having the following data. But I want to convert that into Date Format.How can I achieve this one.

Output want like..Nov-2014,Oct-2014.

Month
2014-11
2014-11
2014-10
2014-12
2014-10
2014-11
2014-12
2014-12

[petter]

LOAD

     ....

     Date( MakeDate( Left( Month,4 ) , Right( Month , 2 ) , 1) , 'MMM-YYYY') AS Date

     ....

FROM

    .....;

[PrashantSangle]

Hi,

try

MonthName(Date#(DateField,'YYYY-MM')

Regards

[qlikmsg4u · Accepted solution]

LOAD Date(Date#(Date,'YYYY-MM'),'YYYY-MMM') as YearMonth;

Load * Inline [

Date

2014-11

2014-11

2014-10

2014-12

2014-10

2014-11

2014-12

2014-12

];