date formatting on headers within attached Excel file to feed data from not recognising date in Qlik

[JoshT]

Hi,

I have uploaded an Excel file to Qlike Sense to work within in an app. However the Excel data in one of the tabs headings which are dates Month/Year are coming through as the number format equivalent in Qlik. See pictures - the first shows the headings in Excel and the second shows the headers as in Qlik.

I want to make the headers show as dates in Qlik - how can I sort this?

Excel

Qlik

Thanks!

[Mark_Little]

Hi @JoshT 

Add the Date Function and Format you want

DATE(field,'mmm-YY') as field

[JoshT]

Thanks Mark - where do I add the date function and format I want? Thanks!