Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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
Anonymous
Not applicable
Author

Hi Phillip,

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

regards,

Raman

vlad_komarov
Partner - Specialist III
Partner - Specialist III

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

VK

kaanerisen
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.

jubarrosor
Partner Ambassador
Partner Ambassador

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.