topic moth format in QlikView

moth format

francis_gr — Mon, 20 Sep 2010 20:10:27 GMT

I`m a new user of qlikview and I have this question

I`m using a numeric field (mes) (from access) with represent the number of the month (1 for January......12 for December) and another field with the year (Año in my access table (4 digits)).

I'm trying to put those fields together using month function

month(mes)&'-'&año, When I see the value of this formula, always put january as month name (in text not number).

I need that formula show for example if mes value 1 and año value 2008....... 01/2008

Thanks for your help!

moth format

Anonymous — Mon, 20 Sep 2010 20:26:16 GMT

This should work:
date(makedate(año,mes), 'MM/YYYY')

moth format

francis_gr — Tue, 21 Sep 2010 11:51:00 GMT

Thanks Michael for your reply!!

Well, this works fine but i`m trying from the script. If i use Month instruction with field mes, always appears january.

Regards

moth format

Anonymous — Tue, 21 Sep 2010 13:40:55 GMT

It should work in the script as well. You're missing something, I guess.

moth format

francis_gr — Wed, 22 Sep 2010 13:23:09 GMT

You're ok!

It works

Thaks again

Regards