In attached excel , I am unable to get the date in required format ie DD-MM-YYYY.
I tried below 2 ways , however its not working.
date(date#(DATE),'DD-MM-YYYY') as Date,
date(DATE,'DD-MM-YYYY') as Date,
Kindly help. Thanks in advance.
date(timestamp#(DATE, 'DD/MM/YYYY hh:mm TT'),'DD-MM-YYYY') as Date
It looks like Excel design not intepret the date column as a date/timeatamp column but a text. That's why you need to use date#() in order to tell Qlik that the column consists of timestamp.