topic I got a problem with the command 'month' in QlikView

I got a problem with the command 'month'

Tue, 02 Sep 2014 22:27:42 GMT

I got a problem with the command 'Month' it returns a name and I need integer.

can anybody help me?.

best regards.

Re: I got a problem with the command 'month'

MarcoWedel — Tue, 02 Sep 2014 22:40:23 GMT

Num(Month(Yourfield))

hope this helps

regards

Marco

Re: I got a problem with the command 'month'

phaneendra_kunc — Wed, 03 Sep 2014 00:03:27 GMT

you can use

NUM(MONTH(FIELD))

Date(FIELD,'MM') -- Assuming FIELD format is in 01/01/2014

Re: I got a problem with the command 'month'

jagan — Wed, 03 Sep 2014 01:48:31 GMT

Hi,

Month(Yourfield) * 1

also returns numeric month, since month is Dual type. By default it will return string month, if you require as number then you have to convert by using Num() or Date(FieldName, 'M') or by multiplying with 1.

Hope this helps you.

Regards,

Jagan.

Re: I got a problem with the command 'month'

ecolomer — Wed, 03 Sep 2014 04:02:42 GMT

For the Month you have some functions:

Month(Date) for the name of month

num(Month(Date) for the number of month

Re: I got a problem with the command 'month'

Wed, 03 Sep 2014 16:17:45 GMT

thanks a lot Marco.

Re: I got a problem with the command 'month'

MarcoWedel — Wed, 03 Sep 2014 17:01:23 GMT

you're welcome

please close this thread if you don't have further questions

thanks

regards

Marco