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 to 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, so "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. These improvements apply automatically, with no schema changes required.
For any issues or feedback, please contact us at help@keel.so.
Thank you for using Keel!