After a little searching I learned there is also a function called Date() to use as your default value in your database columns. I was using Now() which adds all the HR, MIN, SEC stuff behind the date... I'm new to all this, i had no idea.
Anyway, after I set the DA Search behavior to "Greater than or equal to", I can now type in "october 2009", and it'll give me all the orders for Oct 09. Problem solved :)