Changed date to string format read csv file

[MutedJam]

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:

Date serial number to normal date

Many thanks! Looking at these number I assume this is the data format used by Microsoft Excel? Unfortunately, n8n doesn’t have a built in option to convert these. If you control the source sheet, you could explicitly store these values as texts rather than date values. If that’s not an option and you need to convert these values in n8n, you could use a Set node and an expression like {{new Date(Math.round($json["Created at"] - 25569) * 86400 * 1000)}} (found here). This would convert the Excel…