Handle Dates like an Expert | Qlik Sense | Date vs Date#

[@princessmiathehappywoof7747]

Hello, How to convert if i have the date formats like mentioned below.? How to convert to DD-MM-YYYY .? Dateformat [ 01 January 2022, 01 01 2020, 01-01-2022, 12/01/2022, 2022-12-01, ];

[@Qlikkie]

Hi, this will work for your scenario Date(alt(Date# (Dateformat, 'DD MMMM YYYY'), Date#(Dateformat,'DD MM YYYY"), Date# (Dateformat,'DD-MM-YYYY"), Date# (Dateformat, 'DD/MM/YYYY'), Date#(Dateformat, 'YYYY-MM-DD')), 'DD-MM-YYYY')

[@princessmiathehappywoof7747]

Somehow Done to this extent but not able to convert the first date format. Date(Alt(Date(Date#(Dateformat),'DD/MM/YYYY'), Date#(Dateformat,'DD MM YYYY'), Date#(Dateformat,'DD-MM-YYYY'), Date#(Dateformat,'YYYY-MM-DD')),'DD/MM/YYYY'), Date#(Dateformat,'DD MM YYYY')

[@Qlikkie]

Date(alt(Date# (Dateformat, 'DD MMMM YYYY'), Date#(Dateformat,'DD MM YYYY"), Date# (Dateformat,'DD-MM-YYYY"), Date# (Dateformat, 'DD/MM/YYYY'), Date#(Dateformat, 'YYYY-MM-DD')), 'DD-MM-YYYY')

[@princessmiathehappywoof7747]

@@Qlikkie Hello, Thank you so much for the reply. This is working perfect. By the way my name is yeleesha babu. Sorry that i messaged from my pets youtube channel. i didn't notice. Thank you again.

[@Qlikkie]

Happy that it helped, have a nice day!