I can’t do it that way. I cannot use String.Format, .Replace, or anything like it in my code. The FILTER ITSELF must do the “before today” logic.
Odata filter by default is just a filter but not something which would calculate expressions
That’s not correct. There are functions and other things you can use in an odata filter, I just can’t figure out the correct syntax.