Obviously you could use combination of Coalesce and Date# function like
Date(Coalesce(Date#(DATE,'DDMMYYYY'),Date#(DATE,'MMDDYYYY'),Date#(DATE,'YYYYMMDD')),'DD/MM/YYYY')
but.... The problem sits in dates which can support 2 formats like 12012021 - this record can return 1st of December 2021 or 12th of January 2021 and unless you have some indicator which will tell you which format should be used for such record there is no way you can get reliable results.
There was a blog topic which describes those date functions here: https://community.qlik.com/t5/Qlik-Design-Blog/Date-Function-vs-Date-Function/ba-p/1837175
cheers
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
