13 April, 2026
This release fixes relative date filtering semantics and delivers significant list query performance improvements.
Relative Date Calendar Boundaries
Expressions like "last week", "last month", and "next year" in relative date filters now use calendar boundaries instead of rolling windows.
Previously, "last week" produced the same result as "last 7 days" — a rolling 7-day window from the current time. Now, "last week" means the previous ISO calendar week (Monday–Sunday), which matches what users typically expect.
| Expression | Before | After |
|---|---|---|
"last week" | Rolling 7-day window | Previous calendar week |
"last month" | Rolling 30-day window | Previous calendar month |
"next day" | Rolling 24-hour window | Next calendar day |
Expressions with an explicit count like "last 7 days" or "next 3 weeks" remain rolling windows. The "complete" keyword is still supported but is no longer required for two-word expressions — "last week" and "last complete week" now produce the same result.
This change applies to equalsRelative, beforeRelative, and afterRelative operators on both Date and Timestamp fields. Sub-day periods (hour, minute, second) are not affected.
Faster List Queries
List actions that filter through relationships are now significantly faster. Keel now generates more efficient queries and automatically creates database indexes for enum and boolean fields on related models used as filter inputs. These improvements apply automatically — no schema changes required.
Fixes and Improvements
For a full list of fixes and improvements, check out our GitHub releases page (opens in a new tab).
For any issues or feedback, please contact us at help@keel.so.
Thank you for using Keel!