topic Re: Change Date Format from MMM-YY to DD/MM/YYYY in Qlik Sense in Visualization and Usability

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

zela9123 — Thu, 13 Aug 2020 14:05:04 GMT

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 — Thu, 13 Aug 2020 14:10:04 GMT

Hi,

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

zela9123 — Thu, 13 Aug 2020 14:40:37 GMT

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