I think there is a bug in Condition Filter. The “is on or after” is executing as “is on or before” so it’s the other way around.
Hi, thanks for reporting this! Could you help us with a few more details so we can investigate?
- Which specific feature or module did this occur in? (e.g. table filter, workflow condition, chart filter)
- What field type were you filtering on? (e.g. date, datetime)
- Steps to reproduce the issue
- Your NocoBase version
- Any screenshots or screen recordings would also be very helpful!
Hi May,
- Module is Workflow
*Field Type is Date
*The Workflow has a query node that is filtering the TourTransfer Date that is supposed to be is “on or before” Today which means date today or future date in my understanding. The query did not show any results until I changed it to “on or after” Today. The date I tested is 26/05/2026 which is a future date.
*NocoBase v2.0.56
Thanks.
Neihl
Hi leonilotutor-dev,
This is actually working as designed, not a bug! Let me clarify the logic for date filters:
The “on or before” Today condition in NocoBase means “Date ≤ Today”. That includes “today’s date and any past dates before today”, but excludes future dates.
In your test case:
- The date “26/05/2026” is a future date (after today), so it doesn’t meet the “≤ Today” condition. This is why no results showed up initially.
- When you changed it to “on or after” Today, the condition becomes “Date ≥ Today”, which includes today and all future dates. That’s why your test date matched and appeared in the results.
Hope this clears things up.
Hi May,
My apology, I was really confused. That makes sense now. Thank you for your very prompt response.
Neihl.