Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
moteb_marei
Contributor
Contributor

Merge 2 Date Formats

Hello,

I have 2 datasets one is xlsx and another in csv format.

When I loaded the data to qliksense desktop the csv file date field is working but the xlsx one doesn't.

I have tried date(datefield,'DD-MMM-YYYY') and date(date#(datefield,'DD-MMM-YYYY'),'DD-MMM-YYYY') but it doesn't.

When I left it as datefields only it has shown like the attached picture.

Please help.

 

Labels (1)
1 Solution

Accepted Solutions
Vegar
Partner
Partner

It looks like your first dates in the picture is not interpreted as dates. Try something like this.

date(date#(datefield,'MMM, D YYYY'),'DD-MMM-YYYY')

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Vegar
Partner
Partner

It looks like your first dates in the picture is not interpreted as dates. Try something like this.

date(date#(datefield,'MMM, D YYYY'),'DD-MMM-YYYY')

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post