topic Re: How to get a month number in QlikView https://community.qlik.com/t5/QlikView/How-to-get-a-month-number/m-p/1414972#M801242 <HTML><HEAD></HEAD><BODY><P>Wow! So fast hepl! Thank you, it works!</P></BODY></HTML> Fri, 17 Nov 2017 15:26:04 GMT Peony 2017-11-17T15:26:04Z How to get a month number https://community.qlik.com/t5/QlikView/How-to-get-a-month-number/m-p/1414969#M801239 <HTML><HEAD></HEAD><BODY><P>Hello. Trying to get month number from field values like this one:</P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>SomeDate:</P> <P>LOAD * INLINE [</P> <P>SomeDate</P> <P>Oct 2017</P> <P>Sep 2017</P> <P>Aug 2017</P> <P>Jun 2017</P> <P>Oct 2016</P> <P>Sep 2016</P> <P>Aug 2016</P> <P>Jun 2016</P> <P>];</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>I'm getting month name like =mid(SomeDate,1,3). But how to covert the result in month number?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-month-number/m-p/1414969#M801239 Peony 2020-11-25T16:16:04Z Re: How to get a month number https://community.qlik.com/t5/QlikView/How-to-get-a-month-number/m-p/1414970#M801240 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>=Num(Month(Date#(mid(SomeDate,1,3),'MMM')))</P></BODY></HTML> Fri, 17 Nov 2017 15:19:10 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-month-number/m-p/1414970#M801240 swuehl 2017-11-17T15:19:10Z Re: How to get a month number https://community.qlik.com/t5/QlikView/How-to-get-a-month-number/m-p/1414971#M801241 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>Num(Month(Date#(SomeDate, 'MMM YYYY'))) AS MonthNum</STRONG></P></BODY></HTML> Fri, 17 Nov 2017 15:19:52 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-month-number/m-p/1414971#M801241 sunny_talwar 2017-11-17T15:19:52Z Re: How to get a month number https://community.qlik.com/t5/QlikView/How-to-get-a-month-number/m-p/1414972#M801242 <HTML><HEAD></HEAD><BODY><P>Wow! So fast hepl! Thank you, it works!</P></BODY></HTML> Fri, 17 Nov 2017 15:26:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-month-number/m-p/1414972#M801242 Peony 2017-11-17T15:26:04Z Re: How to get a month number https://community.qlik.com/t5/QlikView/How-to-get-a-month-number/m-p/1414973#M801243 <HTML><HEAD></HEAD><BODY><P>Thank you. It is quite right idea.</P></BODY></HTML> Fri, 17 Nov 2017 15:27:47 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-month-number/m-p/1414973#M801243 Peony 2017-11-17T15:27:47Z