I need to place an expression in the criteria row that will return a range of the last six months of ship dates. The expression is DateAdd(“m”,-6,[anotherquery]![MaxOfShippedDate])
The other query has the field of ‘MaxOfShippedDate’ where a total row showing max is present. I am not supposed to figure out what these date ranges are. The expression is supposed to tell me this.
The return that I get is a blank row with no data in it.
