Queries: allow a variable number of days/weeks/months
Currently, filtering on a date can do "before" and "after" but the after/before "what" is a limited set of options (see first image).
It would be extremely useful and helpful if instead of forcing "1" day/week/month or a specific date, we could specify the number of days/weeks/months from either today or a specific date.
In other words, allow for filters like
- [x] days before [today | specific date]
- [x] months after [today | specific date]
For bonus points: allow [specific date] to be the current value of the property used to filter ("Last used" in the screenshot).
For more bonus points: allow [specific date] to be the current value of any other date property in the object.
Use case:
I have an object type for my social media posts which contains that Last used property. I want a filter that gives me the object (instances) that have an empty date or one that is at least [x] months ago. Aim: ensure I don't repeat them too soon (platform rules and variety in my posting).
2 Comments
Sign in to comment
Especially in something like my daily tasks query, I’d love to plan ahead and see what I have for the next week; but not necessarily something that’s I may have planned 6 months into the future.
I agree, we need granular relative date filters for Task queries (e.g., "+2 days")
Goal: Create a Task dashboard with separate tabs for each day of the upcoming week (Monday to Sunday).
Current Problem: Task queries only support filtering by "Today", "Tomorrow", or general ranges like "This week". It is currently impossible to filter for specific upcoming days like "+2 days" or "+3 days" to create dedicated daily tabs.
Proposed Solution: Add granular relative date filters (e.g., "in 2 days", "in 3 days", "in 4 days") to custom query options to allow users to build specific, tabbed views for future weekdays.