apprentice's method works, but I think if your DateFormat is set in a different format than what you have in your DB you can use the following:
Month(Date#(Ship_date, 'MM/DD/YY')) as MonthName
If this doesn't solve your problem, something else is wrong. It works for me in my QV10 and also for apprentice.
Here's how I did it for a field that I had as Period (represented by the ,1)
dual ( string,Period ) as [Fiscal Month] inline
Period, Period as [Fiscal Month]
FROM [\\MANNETAPP01\BST_Shared_Folder\FY12\ATF\OPEX\FY12 Opex Reporting Q2.xlsx]
(ooxml, embedded labels, table is data);