Date not recognized

[spyglass]

KNIME does not recognize date value from a file, I have this excel file that contains data, one of the column contains date, but when I load it to KNIME, it does not recognized, I tried changing data type but no luck

Here’s my data sample.xlsx - Google Tabellen

sample.xlsx (10.2 KB)

Here’s what I’m getting

[lelloba]

Hello @spyglass ,

there is something strange with your Excel file.
I tried to copy and paste your data on a new Excel file and everything was read as expected.

Another thing you could do is change the “posting date” column into the date format and then export the file as csv. Again, this is working on my KNIME.

Have a nice evening,
Raffaello Barri
LinkedIn

[takbb]

Hi @spyglass and @lelloba , this issue rang bells, and whilst it might not be the same root cause, this looks remarkably similar to an issue that was raised here…

Error: Date values are showing "?'

Thanks @ssq From what I can see on Windows 10, there are no clues like the ones you see on the Mac. Certainly not on mine anyway. File preview in Windows Explorer shows this: [image] but the Excel Reader shows this: [image] and I haven’t found anything in my copy of Excel that will tell me the stored locale of the dates, as they just automatically appear in my locale. On the “format cells” dialog it just shows me my locale too, with nothing to suggest the sheet is in actually in any other…

[lelloba]

You have a strong memory @takbb

Seems that resaving the file or saving it as csv should do the job.

Let us know @spyglass

Raffaello

[spyglass]

Saving as .csv fixed the problem, Thanks