'Formula' in GI Conditions
I have a generic inquiry where I need to filter on these conditions:
((ShipDate Between Today and Today+1) OR
ShipDate Between Today and Today+3))
There is no way to create formulas on the conditions tab but there has to be some way to accomplish this seemingly simple scenario...? I feel like I must be missing something obvious.
My solution would be to make a saved filter tab on the results screen that is shared and set to be the default.
Tell your boss I said you deserve a raise! 😉
That works by adding a hidden column using = Day(Today()) and filtering on that in the conditions. Still seems like they should allow formulas in conditions as you can in SQL.