Can you filter date to be less/greater than today without manually updating the date range filter?
@ccpincombe you can accomplish this by writing a beastmode formula and then filtering on the formula.
WHEN TableDate > CURDATE() THEN 'Greater'
WHEN TableDate < CURDATE() THEN 'Less'
Then you would filter either one and never have to update manually.
Great suggestion! Definitely worked.
Would love if it didn't require a beast mode and were able to choose this as a filter option!