Converting a month.num to month.text

[#1]

Can anyone help!

I want to load a date field which is in the excel file as "period" in the following concatenated format YYYYMM eg. 201306

I've split this into Month and Year as follows:

LOAD

left(PERIOD, 4) AS "Year",

right(PERIOD, 2) AS "Month",

How  do I convert the numeric month into a text month within the load statement

does a switch case type statement work or is there a function to convert this?

Please give examples!

[jerem1234 · Accepted solution]

Maybe try something like:

Year(Date#(PERIOD, 'YYYYMM')) as "Year"

e.g. for 201306 will return "2013"

Month(Date#(PERIOD, 'YYYYMM')) as "Month"

e.g. for 201306 will return "Jun"

[#3]

Excellent, that worked perfectly.  My thoughts were heading in the right direction but weren't concluding in anything as efficient as this.

Thanks alot for your help!