Month Extraction

[hkg_qlik]

Hi,

I would like to extract month (eg. Jan) info from a 012013 (monthyear field). Instead of getting 01 as the month output I would like to see Jan as the output from 012013.

Regards,

H

[#2 · Accepted solution]

Hello,

You can try to use MakeDate:

Date(MakeDate(Right('012013',4),Left('012013',2))) as Date,

Month(Date(MakeDate(Right('012013',4),Left('012013',2)))) as Month,

something like this:

Date(MakeDate(Right(MyField,4),Left(MyField,2))) as Date,

Month(Date(MakeDate(Right(MyField,4),Left(MyField,2)))) as Month,

Best regards.

[phaneendra_kunc]

Use this ....

=month(MakeDate(right('012013',4),left('012013',2)))

Replace 012013 with your MonthYear field..