I am trying to create a new view for my list that is filtered if the [Date] field is too far away.
T do this, I am tring to create a calculated column, "DaysAway" with something like this:
=[Date] - [Today]
But I get this error:
Calculated columns cannot contain volatile functions like Today and Me.
So then I could filter this in the view:
[DaysAway] < 7
How can I created a filtered view based on a Date's distance form [Today]?