Changed date to string format read csv file

Describe the issue

After reading CSV/xlsx from local the dates are changed automatically from date formate to string(2022-01-01 to 44562).

What is the error message (if any)?

Please share the workflow

Share the output returned by the last node

Hi @bakarali, that’s technically the value used by Excel and many compatible spreadsheet applications. Unfortunately, there’s no built in feature in n8n to parse these values yet, but you could easily implement such a conversion yourself. Check out this example:

Thanks @MutedJam