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
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel Date - Sense converts my dates to the numerical value

Dear all,

I am trying to import an Excel-file into Sense. Everything seem to work well, except for the date format. When I do the quick import, Sense converts my dates to the numerical value. See included screen dumps. What can I do to make me get the correct date format?

      

  

Please advise.

Best Regards,

Philipp

4 Replies
Contributor
Contributor

Hi Phillip,

I am having the same issue, did you manage to solve this?

regards,

Raman

Partner
Partner

Why don't you just add DATE(YourDateField, 'DD/MM/YYYY') in the script editor?

VK

Creator III
Creator III

Hi Philipp,

I am not familiar with the data manager but you can define the date pattern if you click the date icon on the column as far as I know.

Luminary
Luminary

Hi:

The problem is that you are mixed number and characters in the same field.

You could try define the header size as 1 and later rename the names of the columns:

Best Regards,

Juan P.