Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

krishna20
Valued Contributor II

Multiple Date format in excel issue

Hi Folks,

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.

 

Regards

Krishna

 

3 Replies
Partner
Partner

Re: Multiple Date format in excel issue

hi 

this should do the trick for you 

if(index(Date,'-')>0,date(date#(Date,'MM-DD-YYYY')),date(Date)) as NewDate,

Highlighted
krishna20
Valued Contributor II

Re: Multiple Date format in excel issue

Hi LironBarom,

Thanks for your valuable suggestion , few dates are not showing right format. I want in 'MM/DD/YYYY'.

Attached screenshot for reference. 

Partner
Partner

Re: Multiple Date format in excel issue

hi 

you can change the date format to MM/DD/YYYY in the function 

in your excel some of the dates aren't in January