If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have 2 datasets one is xlsx and another in csv format.
When I loaded the data to qliksense desktop the csv file date field is working but the xlsx one doesn't.
I have tried date(datefield,'DD-MMM-YYYY') and date(date#(datefield,'DD-MMM-YYYY'),'DD-MMM-YYYY') but it doesn't.
When I left it as datefields only it has shown like the attached picture.
It looks like your first dates in the picture is not interpreted as dates. Try something like this.
date(date#(datefield,'MMM, D YYYY'),'DD-MMM-YYYY')
View solution in original post