Google Sheets - Date format error

Questions
#1

Describe the issue/error/question

I am trying to use the new Google Sheet node to do something basic - ie subtract date.
When I do this, it works

image
image976×1452 59.7 KB

However, when I get the same date from Google Sheets instead in the same exact format (after setting the Sheets Column to the exact same format multiple times)

image
image1913×1659 247 KB

I tried with the From Format and without it. I tried with leading zeros for the month and without it.
I get the same error.

What is the error message (if any)?

NodeOperationError: Date input cannot be parsed. Please recheck the value and the "From Format" field.
    at Object.parseDateByFormat (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/DateTime/DateTime.node.js:14:11)
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/DateTime/DateTime.node.js:450:45)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:658:51)
    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:585:68

Please share the workflow

(Select the nodes and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow respectively)

Share the output returned by the last node

Information on your n8n setup

  • **n8n version:0.212.1
  • **Database you’re using (default: SQLite):SQLlite
  • **Running n8n with the execution process [own(default), main]:main
  • **Running n8n via [Docker, npm, n8n.cloud, desktop app]:Docker
#2

I used a Set node and Luxon for now, but this clearly looks like a BUG that may need to be addressed.

Thanks

#3

I guess I am having a bad “Date” day.
Now I am using a simple IF node and copied the same exact value in both sides of the comparison

image
image1874×1094 131 KB

Cant figure out what the error message says or is about !

#4

Can you try

  1. without your date format, it should default to ISO 8601 which almost every service should understand
  2. With a .toString() if the above doesn’t work

Edit: or use .toISO()

#5

@pemontto Not sure if you meant this

image
image1819×993 87.3 KB

Still an error - thanks for your help !

#6

Sorry - some values are actually null so let me recheck - what you said did remove the previous error message - thanks

#7

You’re doing a comparison using the IF node here, I don’t think you need to format at all in that case. Different story when you’re setting fields to send to Google sheets however.