"The first thing you should be aware of is that there are two different functions: Date#() and Date(). The first is anInterpretation function and the second is a Formatting function". That is from this link...good stuff: The Date Function
This is what a possible solution for you would look like.
Date#(MyTextDate, 'YYYY-MMM') as MyDate,
LOAD * INLINE [