XSLX to SpreadSheet Node, Encountering DATE issues

[saica]

Utilizing the newest stable N8N Cloud instance, when I import XLSX or XLS to the SpreadSheet Node, the date field is always formatting to a number value.

Example:
Original Date in XLSX: 6/24/2023
When outputted in Spreadsheet Node: 45101

I think the Spreadsheet node is converting that column to a Number type, but cannot find any sort of fix?

Thanks

[MutedJam]

Hi @saica, this is expected as this is the type of value Excel uses to represent dates.

Perhaps you want to try out this expression I posted a while back to convert such dates?

Still seems to work from giving this a quick go with your first value:

[saica]

Hi @MutedJam,

This works, but it also sets a date to empty cells. I could have another ‘set’ to remove that incorrect date, but I believe it would always be a moving target? Maybe it wouldn’t change if there is no value.