Excel Date - Sense converts my dates to the numerical value

[#1]

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

[Anonymous]

Hi Phillip,

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

regards,

Raman

[vlad_komarov]

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

VK

[kaanerisen]

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]

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.