This content has been marked as final. Show 4 replies
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? I have tried to go via csv-format, and the dates are then correctly displayed, but that gives me the issue of not converting all the package IDs (column A) correctly i.e they are truncated, and are useless for my analysis.
Look at the column Created Date (column D) and you will see that I do not get the real date but the numerical representation. That is of course of no use for me. All date fields get the same conversion (error).