Issues with importing date from excel ad formatting to monthyear

[#1]

I am importing a completion date with the following format but i want to group by on mmm-yy

how can i convert this date field - I have tried date(completiondate,'MMM-YY) but it displays nothing - just dash "-"

Is it better to load the dates with the month year or to format them after the load

The purpose is to build a spreadsheet with 12 months of data per month for completion dates

Thanks

Rick

Please see attachment

[#2]

I had similar problem with importing data. I tried importing from xlsx  and from csv with ; delimiter but the problem persists. I see dates with no selection applied but they disappear when I apply filter by Date because they don't treated as dates.

My data is in csv file on linux samba server. I used

$cut -f -4 --delimiter=' ' filename.csv > filename-1.csv

to cut the time portion from datetime field (it is the fifth last in lines of my csv file) and then importing in QlikView with

load date(OrderDate,'YYYY-MM-DD') as OrderDate

from ......csv file

This solve my problem.

Regards

Valentin

[#3]

To load the table a, I commented the code below and wrote

(ooxml, embedded labels, table is a);

That helped.

Look:

a:

LOAD

  *

FROM

(ooxml, embedded labels, table is a);

//(ooxml, embedded labels, table is a, filters(Replace(1, top, StrCnd(null))));