高手们抢分了access的日期如何比较

高手们抢分了access的日期怎么比较
我用的
select   *   from   persons   where   [date]> '2007-10-10 '
不对
用
select   *   from   persons   where   [date]> 2007-10-10
不准
应该怎么判断呢



------解决方案--------------------------------------------------------
select * from persons where [date]> = #2007-10-10#

------解决方案--------------------------------------------------------
select * from persons where [date]> #2007-10-10#