Issue with Filtering by Date in NocoDB Queries via n8n

Questions
1

Hi everyone,

I’m having trouble filtering records by date when querying a NocoDB table through n8n. I’m using a filter like this:

(status,eq,active)~and(next_email_time,lt,2024-11-26)

But I keep getting this error:

"msg": "'2024-11-26' is not supported."

The next_email_time field is a DateTime field in NocoDB. I tried different formats and even passed the date literally as 2024-11-26T00:00:00.000Z, but the same error persists.

Has anyone faced this issue or knows what might be going wrong? Any examples of working date filters would be greatly appreciated. Thanks in advance!

2

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:
3
  • n8n version: 1.63.4
  • Database: SQLite
  • n8n EXECUTIONS_PROCESS setting: own
  • Running n8n via: Docker
  • Operating system: Ubuntu 24.04
4

Welcome to the community @Marky !

Tip for sharing information

Pasting your n8n workflow

Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.

```
<your workflow>
```

That implies to any JSON output you would like to share with us.

Make sure that you have removed any sensitive information from your workflow and include dummy or pinned data with it!

I would imagine the date is to be passed as a string, not just 2024-11-26 but '2024-11-26' (enclosed in quotes).

5

Hi @Marky, Hi @ihortom

I was having the same issue…
The key is to include the exactDate before your date, like so:

(status,eq,active)~and(next_email_time,lt,exactDate,2024-11-26)

You can find this in the NocoDB documentation (and other ways to filter):

image
image1408×172 11.5 KB

Hope it helps :slight_smile:

3 Likes
6

Bingo, that was it. Thank you very much Ria. Have a nice day.

1 Like
7

I have resolved it with Ria’s advice, anyway, thanks for the interest.

8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.