topic Convert JAN FY2011 into Month Number in QlikView

Convert JAN FY2011 into Month Number

Wed, 02 Mar 2011 12:29:37 GMT

Hi,

I am trying to convert "JAN FY2011" into Month Number.

QlikView would not understand the above format as date, so I need to get the Month Number and Year Number.

I get the Year Number by using Right(Field,4)

But how do I convert the Month Name into Month Number ?

Regards,

Chinmay

deepakk — Wed, 02 Mar 2011 12:39:31 GMT

hi,

You can work around in below way

date(date#(left(field,3),'MMM'),'MM') . this will giev you JAN as 01.

Wed, 02 Mar 2011 12:45:56 GMT

Thanks Deepak

This works but when I try to add 2 to this number is gives a strange result ?

For Jan it gives 1 but when i add 1 to it eg. =date(date#(left(MonthName,3),'MMM'),'MM') +1 it gives me -362

Wed, 02 Mar 2011 12:51:05 GMT

Ok got it working thanks for ur help buddy :

num(month(date#(left(MonthName,3),'MMM'))) +3