Compare date in google sheets

Questions
1

Describe the problem/error/question

If your question hasn’t been asked before, please follow the template below.

image
image987×897 65.7 KB

image
image1183×891 57.7 KB

Information on your n8n setup

  • n8n version: 1.64.2
  • Database (default: SQLite): postgres 16
  • n8n EXECUTIONS_PROCESS setting (default: own, main): how do I see it?
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Unraid
2

Hey @brauliodiasribeiro , the string format expected to have the function toDateTime() applied to is “MM/DD/YYYY”. However, your spreadsheet data appears to be in the format “DD/MM/YYYY”. Hence the error you get.

3

Tks for this information…I’ll try…