NEED HELP: Unable to filter by date from google sheet

[AKP14]

Error in parsing the date while filtering the data by dates from Google Sheets

Workflow:

Error:

Hello all,
I’m new to N8N, I was tring to filter some data from a google sheet by dates, but no matter what I try it shows invalid DateTime, even for Datetime.now().
You can see in the images below.

Information on your n8n setup

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

[mohamed3nan]

Welcome @AKP14 to the community !
Does this node work on your instance?

[AKP14]

Hey @mohamed3nan ,
The current date node was not working because I hadn’t set the timezone in my workflow. After setting the timezone, it worked. Surprisingly, my issue was also resolved after setting the timezone. Can you tell me why timezone setting is needed for creating DateTime from a string?

[mohamed3nan]

Could you check your environment variable to see if you’ve set GENERIC_TIMEZONE correctly? The workflows should use the default time from it if not set, and if it’s set incorrectly, that might be the issue.

[AKP14]

Yes. The GENERIC_TIMEZONE was incorrect. But why is the timezone setting needed to create DateTime from a string?