Merge 2 Date Formats

[moteb_marei]

Hello,

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.

Please help.

[Vegar · Accepted solution]

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')