Need variable past/future daily date range with ability for user to adjust
I have a number of cards where I need to present daily data with a range of past and future dates. I've found that I can easily fix the date range, and this then still gives users the ability to modify the dates when using the card. This last part is where I am having trouble, as I know I can use a beast mode to create a rolling past/future date range (see example below), but when I do that, it eliminates the ability for a user to then make adjustments to view dates outside of that range.
/*Plus/Minus 60 days*/
case when (DATEDIFF(`APPOINTMENTDATE`, CURRENT_DATE())<=60) and (DATEDIFF(`APPOINTMENTDATE`, CURRENT_DATE())>=-60) then 'Include'
When the dates needed are all historical or all future, the ability to modify by a user still exists. It's only when it includes the past and the future that I run into this difficulty.
Thanks for any help you can provide!