Discussion board where members can get started with Qlik Sense.
I am having excel data which holds date in two different formats. Tried Date,Date#,alt,floor functions but no luck.
Can anyone look into this and light up on this issue. Sample data has attached.
this should do the trick for you
if(index(Date,'-')>0,date(date#(Date,'MM-DD-YYYY')),date(Date)) as NewDate,
Thanks for your valuable suggestion , few dates are not showing right format. I want in 'MM/DD/YYYY'.
Attached screenshot for reference.
you can change the date format to MM/DD/YYYY in the function
in your excel some of the dates aren't in January