topic Problem with month() in QlikView

Problem with month()

asa_runstrom — Fri, 18 Feb 2011 11:07:58 GMT

When I write month('2011-01-01') I get the answer 1,2,3,4,5,6,7,8,9,10,11,12 which is not what I want but i works when I write month('2011-02-01') it write feb and with month('2011-03-01') it write mar. How do I do to get jan with month('2011-01-01')? I use developer 8.5.

Problem with month()

tresB — Fri, 18 Feb 2011 11:30:51 GMT

Hi,

Have you checked it in a text object? it should work fine. are you trying it with some field value or directly with string as you wrote in the post?

Regards, tresesco

Problem with month()

Fri, 18 Feb 2011 11:40:26 GMT

Check the "SET MonthNames" line in your script:

If it contains numbers change it like this:

SET MonthNames = 'jan;feb;mar;apr...'

Problem with month()

suniljain — Fri, 18 Feb 2011 11:43:08 GMT

=Month

(Makedate(LEFT('2011-03-01',4),MID('2011-03-01',9,2),MID('2011-03-01',6,2

)))

Problem with month()

asa_runstrom — Fri, 18 Feb 2011 12:27:50 GMT

I have tried it in a textobject all 3 on the same time and got the answer 1,2,3,4,5,6,7,8,9,10,11,12 feb mar. I think it is strange that i work with feb and mar but with jan.

I have tried it it with string and with a field value.

This is not in a new application, it has worked severel months but suddenly get the wrong answer for 2011-01-01.