topic Re: Date Conversion in QlikView

Date Conversion

Mon, 08 Jun 2015 07:45:08 GMT

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.

petter — Mon, 08 Jun 2015 07:48:50 GMT

LOAD

....

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

....

FROM

.....;

PrashantSangle — Mon, 08 Jun 2015 07:49:26 GMT

Hi,

try

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

Regards

qlikmsg4u — Mon, 08 Jun 2015 07:50:29 GMT

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

Load * Inline [

Date

2014-11

2014-10

2014-12

2014-10

2014-11

2014-12

];