access数据库按日期类型查询数据报错！

select * from sv_JFVoucher  
where isDelete=0 
 and  [date]>= '2015-1-20 0:00:00'
  and  [date]<= '2015-1-20 0:00:00' 
  order by id desc

这条sql 语句在SqlServer08中执行是无错误的，可是在access数据库中执行就报错！

百度了一下，说把

'2015-1-20 0:00:00'修改成#2015-1-20 0:00:00#

select * from sv_JFVoucher ?

where isDelete=0 
 and  [date]>= #2015-1-20 0:00:00#
  and  [date]<= #2015-1-20 0:00:00# 
  order by id desc

运行真的成功了，我刚接触access，表示不解