Hello everyone? Are you all doing well?
I have a small problem with N8N. Can someone help me?
Here’s the issue: I have stored my Excel file in a database. Then, I make an API Request to retrieve the row containing the file. After that, I use another API Request to fetch the file, and I use the Spreadsheet module to read the data from the file.
My problem is that I can’t get the date formats from the file. I have enabled “Read as String,” but it gives me an error. My date formats are in numbers that only Excel can translate into dates.
Information on your n8n setup
- n8n 0.225.2
- Database using:Baserow
- Running n8n with the execution process [own(default), main]:own
- Running n8n via [Docker, npm, n8n.cloud, desktop app]:Docker
Hi @Micka_Rakotomalala, I am very sorry to hear you’re having trouble
The date format you are seeing (values such as 44562 or 44047) are no actual errors, but instead are how Excel stores dates. n8n does not have built-in functionality to automatically convert these, but you can use a Set node with a bit of Excel specific logic to process these. Check out Date serial number to normal date - #4 by MutedJam for details and please do let me know if you are still running into any trouble with this
Hello @MutedJam, thank you very much for your reply.
I used a code node to solve the date problem. I couldn’t answer because I was away for a while.
That’s solved, thank you very much.
I’ll test in the set node as you said, it’s faster and more efficient.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.