date query problem in query analyzer

i tried to check my query in query analyzer even then its not giving the correct answer.
the query is

select status from t_auction where endDate > 12/5/2003

it gives me all four result and if i change greater than sign with less than then no result

heres the end dates
11/23/2003
11/27/2003
12/6/2003
12/24/2003Originally posted by waqas
i tried to check my query in query analyzer even then its not giving the correct answer.
the query is

select status from t_auction where endDate > 12/5/2003

it gives me all four result and if i change greater than sign with less than then no result

heres the end dates
11/23/2003
11/27/2003
12/6/2003
12/24/2003

Just enclose your date to a single quote
like
select status from t_auction where endDate > '12/5/2003'

and then try again...

-bernie|||thanx :)