Hi I am doing a report that reports on certain data for the previous day as well as month to date. I was using just a record select in MonthToDate to get the MTD but then I realized that this won't work for the first of the month when I would like to get data for the previous month. What would be the formula to get the previous month of data when the print date is the 1st of the month?
Ideally I would like to put that into record selection although that might not be possible.

Thanks!