Wrong date format in Excel after extracting date from PDF

Questions
1

Describe the problem/error/question

I am extracting a date from a PDF document using the “Extract from PDF” node. I then use a Code node to filter the date from the output, pass it through a Merge node, and finally write the data into an Excel file.
My problem is that the date has the wrong format once it is written into the Excel file. It is either not recognized as a native Excel date or displays incorrectly. How can I format or parse the date string in n8n before the Excel node so that Excel recognizes it as a proper date format?

What is the error message (if any)?

no Error message

3

Hi @Benry_Hendix
I think first you need to parse it into a proper datetime object like this after your code node is done extracting it.
{{ DateTime.fromFormat($json.dateField, 'dd/MM/yyyy').toISO() }}
Now the Excel format is still not compatible in most cases, that should be Format: YYYY-MM-DD basically this:
{{ $json.dateField.toDateTime().format('yyyy-MM-dd') }}
Let me know how this goes.