Okay, I used the following code:
Date(OrderDate,'MMMM') AS Month
I am getting multiple values for the months whereas I am only expecting one value for each month name. When I use the original code,
Month(OrderDate) AS Month
I only get each individual month name.
Also, is the function called MonthsName used for long month names? It appears to require 2 parameters.