moth format

[francis_gr]

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!

[Anonymous · Accepted solution]

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

[francis_gr]

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

[Anonymous]

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

[francis_gr]

You're ok!

It works

Thaks again

Regards