topic How to get the Month Number from a Date field in QlikView

How to get the Month Number from a Date field

Mon, 29 Jun 2015 14:47:13 GMT

Hi There

I have a date field in the format DDMMMYYYY and in addition to the standard date information that I am extract from that field (i.e. month name, week commencing etc) I want create a field with the month number.

So the date of '01APR2015' should give me 4.

Any help appreciated.

Re: How to get the Month Number from a Date field

Anonymous — Mon, 29 Jun 2015 14:53:53 GMT

=date(date#( '01APR2015' ,'DDMMMYYYY'),'M')

Re: How to get the Month Number from a Date field

maxgro — Mon, 29 Jun 2015 14:58:19 GMT

=num(month(date#( '01APR2015' ,'DDMMMYYYY')))

Re: How to get the Month Number from a Date field

Mon, 29 Jun 2015 15:00:48 GMT

Fantastic, thank you!

Re: How to get the Month Number from a Date field

Mon, 29 Jun 2015 15:01:12 GMT

Brilliant, Thank you

Re: How to get the Month Number from a Date field

rwunderlich — Mon, 29 Jun 2015 17:42:46 GMT

Bill,

Your solution does not return the month number. It runs the same date with a display format of "M".

=date(date#( '01APR2015' ,'DDMMMYYYY'),'M')

=date(date#( '14APR2015' ,'DDMMMYYYY'),'M')

would create two rows in a listbox or chart which is probably not what the poster wants.

-Rob