Discussion Board for collaboration on QlikView Scripting.
I have the following table:
How do I solve the mix format of dates in the Date field to a single consistent format of DD/MM/YYYY?
I have tried using Date, Date#, MakeDate functions but did not have much luck solving the problem. My attempts ended up excluding the string based dates.
How can I solve this?
You can try this with Alt and Date# functions
Date(Alt(Num(Date), Num(Date#(Date, 'DD-MMM-YYYY')), Num(Date#(Date, 'DD/MM/YYYY')))) as Date
Date( Alt(Date#(DATEFIELD,'DD-MMM-YYYY'), Date#(DATEFIELD,'DD/MM/YYYY') ),'DD/MM/YYYY') AS DATEFIELD,