Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
You can work around in below way
date(date#(left(field,3),'MMM'),'MM') . this will giev you JAN as 01.
hi,
You can work around in below way
date(date#(left(field,3),'MMM'),'MM') . this will giev you JAN as 01.
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
Ok got it working thanks for ur help buddy :
num(month(date#(left(MonthName,3),'MMM'))) +3