
Originally Posted by
southshorepizza
Actually that is part of that customization. There are future orders. But the query should be tweaked so it's between 00:00:00 and now.
Untested, but:
Code:
DATE(date_purchased) = DATE(CURRENT_DATE()) and date_purchased < NOW()
Would query on all orders for the current date (current and "future", assume though that you have more past orders than future orders.