I have created a BAQ that works as would be expected before I added some “Table Criteria”.
Using the table ERP.Order.Hed,
I selected the Field “OrderDate”, Selected Operation “<”, and set Filter Value to “CurrentDate-90Day(s)”.
The problem is that it is returning orders with “OrderDate” dates going back to 2011.
Any guesses as to what is going on?
Are you trying to pull orders with dates within the last 90 days? If so, you should say that the order date is greater than (>) CurrentDate-90Day(s).
The way you have it right now is pulling all orders with dates prior to 90 days ago.
1 Like
To quote Homer Simpson… “DOH!”
It was as simple as that. I had my operand reversed.
I was looking everywhere else but that.:
THANK YOU!
1 Like
I laugh at myself still for having to use the trick I learned in elementary school:
“The alligator eats the bigger number”
3 Likes