I want to add a filter to the report in the report designer. The filter is based on the LastModifiedDate of the AMMTran object. So far, I have tried
=DateAdd(Today(),'d',-1) and Today(), but both these filters are not fetching the data correctly
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/155d12e6-5dd1-48f7-86c9-fb4b5bbfe7fe.png)
How do I get the date filter to work?
Thank You.