怎么比较日期

[btwd]

access数据库，表1 中 有一 "日期" 字段 ，格式为"日期/时间"，date1,date2为date型变量。
查询语句 ： "select * from 表1 where [日期] between " & date1 & " and " & date2 ，执行结果不对，为什么？

[cbzdream]

"select * from 表1 where [日期] between '" & date1 & "' and '" & date2 "

[cbzdream]

"select * from 表1 where [日期] between '" & date1 & "' and '" & date2 "'"

[_131_]

"select * from 表1 where [日期] between '#" & date1 & "#' and '#" & date2 "#'"

[victorycyz]

"select * from 表1 where [日期] between #" & date1 & "# and #" & date2 "#"

[pcwak]

select * from 表1 where [日期] between '#" & date1 & "#' and '#" & date2 "#'

[饮水需思源]

access数据库为：
"select * from 表1 where [日期] between '" & date1 & "' and '" & date2 &"'"

sql数据库为：
"select * from 表1 where [日期] between # " & date1 & " # and # " & date2 & " #"

[饮水需思源]

'刚才写反了

SQL数据库为：
"select * from 表1 where [日期] between '" & date1 & "' and '" & date2 &"'"

access数据库为：
"select * from 表1 where [日期] between # " & date1 & " # and # " & date2 & " #"

[lxcc]

有时候需要加 date1 & "00:00:00"
"select * from 表1 where [日期] between '" & date1 & "00:00:00" & "' and '" & date2 & "23:59:59" &"'"

[younglove]

"select * from 表1 where [日期] between '" & date1 & "' and '" & date2 "'"
这样就可以吧!
我就是这样 弄得

[zhangyp]

"select * from 表1 where [日期] between '" & date1 & "' and '" & date2 "'"