Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
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
ramanm43
New Contributor

Re: Excel Date - Sense converts my dates to the numerical value

Hi Phillip,

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

regards,

Raman

vlad_komarov
Valued Contributor II

Re: Excel Date - Sense converts my dates to the numerical value

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

VK

kaanerisen
Contributor III

Re: Excel Date - Sense converts my dates to the numerical value

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.

jubarros
Contributor II

Re: Excel Date - Sense converts my dates to the numerical value

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.