Is there way to save filter with a relative date.
Hi All,
I have a record type with one of the filters on this record is a Date Range filter on a due date field.
Several departments want to save a view where the filter always defaults to "Today". but when Users save the filter with today's date selected, it saves the literal date (12-08-2026) rather than a relative reference. So the saved filter becomes stale the next day instead of always reflecting the current date. ( Default in the user filters doesn't make much sense because users will combine this due date filters with several other filters).
Is there a way to save a Date Range filter so it stores a relative value rather than a fixed date, so it stays dynamic across days?
As a option B, I'm considering adding a new filter with a dropdown that offers options like "Until today" / "Future Cases," which I could implement with relative date logic. But that would mean maintaining two separate filters for the same column (the original Date Range plus this new dropdown), which isn't my preferred option.
Has anyone found a cleaner way to do this either through a native Appian feature I'm missing, or a design pattern that avoids duplicating the filter?
Thanks in advance!
