topic Re: Issue Related to Month Date Format in QlikView

Issue Related to Month Date Format

Giovane — Mon, 26 Jan 2026 18:19:17 GMT

Who can help me?

When I do Month(Date) - And Date has the format DD/MM/YYYY - I got, for example, dez as the result. How do I do to get 12, instead of dez, as the result?

Thanks a lot !!!

Re: Issue Related to Month Date Format

m_woolf — Fri, 25 Jan 2019 13:28:06 GMT

Try:

num(Month(Date))

Re: Issue Related to Month Date Format

nilaksh92 — Fri, 25 Jan 2019 13:33:37 GMT

Please try to implement like this.

=Num(Month(Date(now(),'DD/MM/YYYY')))

Re: Issue Related to Month Date Format

MindaugasBacius — Fri, 25 Jan 2019 13:46:03 GMT

I would like to improve Mwoolf solution a liitle:
Num(Month(Date), '00')

Now you will get 01, 02, 03 ... 12. In times when you will for example concatenate Year and Month as 2019-01, 2019-02, 2019-03 ... 2019-12 that will provide consistent visualization.
Without formatting you will get 1, 2, 3 ... 12 and Year month field will look like this 2019-1, 2019-2, 2019-3 ... 2019-12.

Re: Issue Related to Month Date Format

Giovane — Sat, 26 Jan 2019 00:27:15 GMT

Best answer...your tip fixed completely my issue.

Thanks for all the contributions.