Relative Date Filters For "is in the previous or current" and "is in the current or next"

[pivers11]

When you want your date dim to span a relative period for last year plus next month (e.g. appointments, some that have not happened yet), you can do a filter like this (is in the previous 365 days OR is in the next 30 days) . The problem is that the relative next/prev are non-inclusive of the current period, so do not include today. Same of any timeframe, if I said last year or next year in 2025, 2025 does not appear, just 2024 and 2026.  You are forced to use absolute dates meaning periodically updating your code as time advances.

Suggestion, add options for: 

• is in the previous or current
• is in the current or next

[pivers11]

We found a workaround, which is horrible. Incidentally, the suggestion value would read better as "is in the current or previous' [3] [Years].

1. From the DateValue filter, select Date Filters::Between 
2. Click (Advanced) 
3. Click [Add Clause] 
4. Click back to (Basic) 
5. Select 
6. [is in the previous] [2] [Years] 
7.   (or) 
8. [is in year] [This Year] 
9.   (or) 
10. [is in the next] [1] [Years]  
11. Read the conditions to make sure the logic is what you want 
12. Click [OK] and “Close & Apply” on the top left of the toolbar