Converting dates in Qliksense

[Aspiring_Developer]

Hello All,

I have below date :-

I wish to convert it into dd/mm/yyyy format .

I have tried below :-

MONTHname(Date#(ISSUE_CLOSED_DATE,'DD/MM/YYYY')) as ISSUE_CLOSED_DATE_test

But it giving me blank results. I am assuming that it is varchar format , so i tried to convert it into number using num function , however it didn't work.

Can anyone please help ?

[hic · Accepted solution]

Date(Date#(ISSUE_CLOSED_DATE,'DD-MMM-YYYY'),'DD/MM/YYYY') as ISSUE_CLOSED_DATE

See also https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157