topic Re: Date format in QlikView

Date format

Tue, 12 Mar 2013 11:39:48 GMT

Hi all,

I'm having trouble converting the date format eg. 201202, into Monthyear ie. Feb-2012

I've tried a number of different expressions, but seem to be going around in circles.

Any ideas?

Many thanks

Gysbert_Wassenaar — Tue, 12 Mar 2013 11:44:25 GMT

date(date#('201202','YYYYMM'),'MMM-YYYY')

Tue, 12 Mar 2013 11:53:33 GMT

Hello Beanz,

You can try this:

Test:

LOAD * INLINE [

Dates

201202

201201

201204

];

LOAD replace(MonthName(MakeDate(left(Dates,4),right(Dates,2))),' ','-') as DateNew Resident Test;

Let me know if it was helpful, or anything else is required.

thanks,

itsangad

Tue, 12 Mar 2013 11:55:17 GMT

@Gysbert surely has given a better solution.