By using this website, you agree to our Terms of Use (click here)
I have an issue with 2020.3 upgrade and AR Aging reports. I need to be able to conditionally use @Today in the report filter (depending on a new boolean parameter that I added to the report which triggers use of today's date instead of the specified Aging Date).
As a test I replaced all instances of @AgeDate with @Today assuming that @Today was a built in parameter.
The report returned no output at all. So i can only assume that either @Today doesn't work as a report filter, or there's an issue in the 2020.3 sandbox we are testing in.
Does anyone know whether @Today really is supported in Schema Builder -> Filter (in the Value column)?
I can answer my own question now. Didnt have any luck with @Today, but it worked with =Today(). So formulas can be used in the Value columns of Filters even though you cant get to the formula editor from the UI. I got the report working with this filter.
Very interesting. I didn't realize you could do this. Thanks for sharing @roycelithgo.