either make sure you're using US date format in your SQL or use datevalue() function.


FireBeast