Date in google sheet european format

[nusquama]

Hi,

I’m encountering an issue with dates in Google Sheets when integrating with n8n. Here’s the problem:

1. In my Google Sheet, the dates are in European format (dd/MM/yyyy).
2. When n8n reads these dates, it doesn’t recognize them as dates but instead interprets them as strings.
3. If I change the format in Google Sheets to American style (MM/dd/yyyy), n8n correctly recognizes them as dates.

However, I prefer to keep the European date format in my Google Sheet. Is there a way to make n8n correctly interpret European-format dates without changing the format in Google Sheets?

Any suggestions on how to resolve this would be greatly appreciated. Thank you!

Debug info

core

• n8nVersion: 1.50.1
• platform: docker (self-hosted)
• nodeJsVersion: 20.15.0
• database: postgres
• executionMode: regular
• concurrency: -1
• license: community
• consumerId: unknown

storage

• success: all
• error: all
• progress: false
• manual: true
• binaryMode: memory

pruning

• enabled: true
• maxAge: 336 hours
• maxCount: 10000 executions

Generated at: 2024-07-24T14:36:29.186Z

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[nusquama]

Ok i found a solution but its cannot be more simple than this !
So i use date to get the date i want and format in MM/dd/yyyy because its look like n8n dont recognize dd/MM/yyyy.
in option you can say in which format its your original date

[mcnaveen]

Glad you found the solution, Can you try the formatting options like in the below screenshot.

[nusquama]

its not working
for n8n date in format european, like dd/MM/yyyy is not recognize like a date, but like a string. i have to convert date or change my format in my google sheet…