Change Date Format from MMM-YY to DD/MM/YYYY in Qlik Sense

[zela9123]

Hi All,

I want to convert date format like 'Jan-20' to 01/01/2020. Can some help me with that ?

Thanks a lot in advance.

Best regards,

Zela

[Gabriel]

Hi,

Try this =DATE(DATE#('Jan-20','MMM-YYYY'),'DD/MM/YYYY')

[zela9123]

Hi,

When I have uploaded sample data without changing anything, in Qlik Sense it appears as: 'January 2020' etc.

Please see attached sample data and screen from Qlik.

@Gabriel in such situation, solution suggested by you is not working 😞

Best regards,

Zela