Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try
=Num(Month(Date#(mid(SomeDate,1,3),'MMM')))
May be try this
Num(Month(Date#(SomeDate, 'MMM YYYY'))) AS MonthNum
Wow! So fast hepl! Thank you, it works!
Thank you. It is quite right idea.