Changing Numerical month year to month name and year

[Anonymous]

I have attatched the data. I need them to say Mar-12 instead of 03-12.  When you pull it into Qlik, it does not pull the data in as shown in the excel sheet. It pulls it in in a bunch of numbers.  In the data load I changed it to Date(date) and that made it change to 03-12 but I cannot get the month to come in as the name not numerical. Any help would be appreciated!

Thank you!

Ariana

[jonathandienst]

Just use:

LOAD Date(Date, 'MMM-yy') as Date....

[daniel_kusiak]

Hi, try this

LOAD date(Date,'MMM-YY') as date

FROM

[Chain Dates.xlsx]

(ooxml, embedded labels, table is Sheet1);

[jonathandienst · Accepted solution]

Looking at your source, there are days as well. To get proper month values:

     LOAD Date(MonthStart(Date), 'MMM-yy') as Date....