Question Locked
query criterion: DateAdd, Microsoft Access 2007
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.