Skip to main content
gokulv299689
New Participant
August 12, 2026
Question

Is there way to save filter with a relative date.

  • August 12, 2026
  • 3 replies
  • 38 views

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!

 

 

    3 replies

    venkatrea696188
    Inspiring
    August 12, 2026

    Hi Gokul,
    You can directly do that in record filter(You can set Default values ), Let me know if you are looking for something different
     

     

    gokulv299689
    New Participant
    August 12, 2026

    Please check my description again, I mentioned about Default filters

    peter.lewis
    Employee
    August 12, 2026

    Yeah my suggestion would be like you said: create a dropdown with dynamic dates (today, yesterday, last 7 days, etc.) because then you could save that correctly.

    Otherwise I can’t think of a way to do this using a date range filter. Your other option could always be creating your own filter saving mechanism by using regular interface components (not user filters) and write data to the database to store selections. However, that’s likely quite a bit more work to set that up.