Data Filter Issue

[suet-yin]

Describe the problem/error/question

Data filters are excluding data that should qualify based on filter setting

What is the error message (if any)?

Please share your workflow/screenshots/recording

{
"nodes": [
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "loose",
"version": 2
},
"conditions": [
{
"id": "efc93c15-e9da-4789-8def-a25bdce780cb",
"leftValue": "={{ $json.date }}",
"rightValue": "={{ $('On form submission').item.json['Start Date'] }}",
"operator": {
"type": "dateTime",
"operation": "afterOrEquals"
}
},
{
"id": "4d9129a7-3d5d-4ea0-b62f-b65aa769b159",
"leftValue": "={{ $json.date }}",
"rightValue": "={{ $('On form submission').item.json['End Date'] }}",
"operator": {
"type": "dateTime",
"operation": "beforeOrEquals"
}
}
],
"combinator": "and"
},
"looseTypeValidation": true,
"options": {}
},
"type": "n8n-nodes-base.filter",
"typeVersion": 2.2,
"position": [
592,
0
],
"id": "cdef3d7b-c7dd-4c4b-8d7d-d87f0b81a363",
"name": "Filter by Date Range"
}
],
"connections": {
"Filter by Date Range": {
"main": [
[]
]
}
},
"pinData": {},
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "9c4beffcab657ecdb53935790fbfc63f0a4f1167ccc473bcc1cac1969d3b230d"
}
}

Share the output returned by the last node

This specific section is causing the issue.
{
"id": "efc93c15-e9da-4789-8def-a25bdce780cb",
"leftValue": "={{ $json.date }}",
"rightValue": "={{ $('On form submission').item.json['Start Date'] }}",
"operator": {
"type": "dateTime",
"operation": "afterOrEquals"
}

The Start Date from the form is 2024/04/01 so any entries that are April 1st and beyond should be selected.

Debug info

core

• n8nVersion: 1.102.4
• platform: docker (cloud)
• nodeJsVersion: 22.17.0
• database: sqlite
• executionMode: regular
• concurrency: 5
• license: community

storage

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

pruning

• enabled: true
• maxAge: 168 hours
• maxCount: 2500 executions

client

• userAgent: mozilla/5.0 (macintosh; intel mac os x 10_15_7) applewebkit/537.36 (khtml, like gecko) chrome/138.0.0.0 safari/537.36
• isTouchDevice: false

Generated at: 2025-07-19T16:58:21.844Z}

[Joffcom]

Hey @suet-yin,

Thank you for reaching out! We’ve received your issue and are looking into it. To help us track this internally, we’ve created a Linear ticket with the reference: "GHC-3207".

We’ll keep you updated as we make progress, but if you have any additional details or context to share, feel free to add them here - it’s always helpful!

Thanks for your patience and for bringing this to our attention.

[n8n-assistant]

Hi @Suet 👋

Thanks so much for your patience while we’ve been improving n8n. We know it’s taken some time to review this issue, and we’re currently updating our triage process to better keep up with our growth.

There have been a lot of improvements in recent releases, so we’d really appreciate it if you could check whether this issue still occurs in the latest release.

When you have a moment, please copy and paste the checklist below as a comment so our system can update the status automatically:

[ ] I have updated to the latest stable version of n8n [please specify version number] and I am still experiencing this issue
[ ] Please close this issue – I am no longer experiencing it
[ ] Please close this issue – [please specify a reason]

If we don’t hear from you in the next 14 days this issue will be automatically closed, feel free to reopen - don’t forget to add the checklist above so that our automated systems notify us of the issue.

Thanks again for helping us keep n8n healthy and up-to-date 💚

[n8n-assistant]

As we haven’t heard back from you, we’re going to close this issue to keep things organized. But don’t worry, if you have more information or need further assistance, you’re welcome to reopen the issue anytime or create a new one. We’re always happy to help!

Thanks for reaching out and have a great day! If this was closed by mistake and you have been waiting for us let me know and I can also re-open it.