Converting Month Numbers Shows only Jan and Dec

[greend21]

We are using SQL to pull the month, which then gets loaded into Qlikview as the month number. When I try converting these to month name In Qlikview it will only show January and December even though all calendar months should be there. Do you know what is causing this?

[sunny_talwar]

Can you show the month number field you get from SQL? and also, what do you do to convert it? I mean what script do you use?

[greend21]

MONTH(actual_bill_date) ActBillMo is the SQL line which results in the 1-12 numbers.

Month(ActBillMo) as ActBillMo returns only Jan & Dec

[sunny_talwar · Accepted solution]

Try this instead

Month(Date#(ActBillMo, 'M')) as ActBillMo