How to get a month number

[Peony]

Hello. Trying to get month number from field values like this one:

SomeDate:

LOAD * INLINE [

SomeDate

Oct 2017

Sep 2017

Aug 2017

Jun 2017

Oct 2016

Sep 2016

Aug 2016

Jun 2016

];

I'm getting month name like =mid(SomeDate,1,3). But how to covert the result in month number?

[swuehl · Accepted solution]

Try

=Num(Month(Date#(mid(SomeDate,1,3),'MMM')))

[sunny_talwar]

May be try this

Num(Month(Date#(SomeDate, 'MMM YYYY'))) AS MonthNum

[Peony]

Wow! So fast hepl! Thank you, it works!

[Peony]

Thank you. It is quite right idea.