Month to month number

[#1]

Hi,

can anybody suggest how to get month number from month like 'Apr' to 04, Is there any specific function available in qlik view

Thanks & Regards,

Arun

[#2]

Hi Arun

Enter "date" in the search field of the help. You will see an entry "Date and time functions".

=month(now()) will give you the month name

=num(month(now())) will give you the month number

QlikView has in most cases a numeric and string representation for values (I strongly suggest to read through part II of book 2 in the documentation, "Data Types in QlikView")

Regards

Jürg

[#3]

Hi Arun,

you can sole your question by usung this code....

num(month(field name)). Hope this helps

Thanks joseph.....

[#4]

In addition to juergm' and joseph.thoppil' answers: you can add format-code to obtain your month in two figures [01, 02, 03 ... 12].

num(Month(field name), '00')

Bye

Marco.

[Anonymous]

Hi,

Check this link,

http://community.qlik.com/thread/34277

[rohit214]

hey arun

use

num(month(now()))

thanks

rohit

[#7]

Hey Arun

try this

(monthnum(date_field))

thanks

Rathish