Select query problem for different date ranges

Question

hi,
   I am getting problem in SQL select query.
For ex: Select * from table where date>='12/25/2009' and date<='01/15/2010'
Please tell me why this select query is not working for daterange between different year.