Notion manual filter on get doesn't work with Equals Date

Questions
1

Describe the problem/error/question

Notion manual date filter on “Equals” to date seems broken

Long story short. Notion Date compare using Equals might involve also Time (which is not shown in Notion if set as Date without time). This breaks equality check.

See, this is a number of records with today date:
image

Trying to use “Equals” - no returned records

image
image1158×565 35.9 KB

Trying to use “On or after” - returns everything what needed:

image
image1245×635 41.4 KB

By the way, “On or before” will not work, because I guess it compares also time (though it’s not shown). So the records have time like 2024-10-21 13:15:55, which means it doesn’t satisfy the filter (which is On or before 2024-10-21 (00:00:00).

image
image776×621 26.9 KB

It works if “On or before” is compared with the TOMORROW date, which is kinda wrong. If my date in Notion is 21 October, then “On or before” 21st of October must return the item.

image
image1012×631 38.8 KB

Please share your workflow

Information on your n8n setup

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

Hey @artildo , you are right. When using just 2024-10-21 it implies 2024-10-21 00:00:00. Hence the outcome you got. You have to take into account the time too. The name of the field “Date” appears to be misleading as it actually DateTime.

3

Hi @ihortom, thank you for the answer

This should be fixed? I guess when a Date format (without time) is accepted, the Time part of the record should be cut away (in Notion node).

Otherwise the equality date filter is just useless. Or used with workaround:

  • Create tomorrow date via Date and Time
  • Add two filters: On or after “Today” and Before tomorrow
4

Hey @artildo , I ran a few tests on my own Notion database and it appers to be working as expected, I cannot reproduce an issue related specifically to dates. That is, while internally the date is represented together with time, the condition works on date regardless of time.

image
image1304×984 54 KB

You do have some other conditions mixed. Perhaps they play some role in what you expirience.