DateDiff的Sql问题,提示“[ODBC Microsoft Access Driver] 标准表达式中数据类型不匹配。”哪位碰到过类似问题的，请进

[海大富运动]

数据库类型（access)
mstartworktime是时间类型

sql="select * from WorkLog where MStartWorkTime between '" & sDate & "' and '" & edate & "' and uid='"&username&"'"

出错如下:

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e07'

[Microsoft][ODBC Microsoft Access Driver] 标准表达式中数据类型不匹配。

/test/11/Search.asp，行 23

[welcome403]

sql="select * from WorkLog where MStartWorkTime between #" & sDate & "# and #" & edate & #' and uid='"&username&"'"

[welcome403]

应该是

sql="select * from WorkLog where MStartWorkTime between #" & sDate & "# and #" & edate & "# and uid='"&username&"'"

[beecky]

select * from WorkLog where (MStartWorkTime between '" & sDate & "' and '" & edate & "') and uid='"&username&"'

[beecky]

另外时间的比较也可以用大于、或小于来比较
MStartWorkTime >=" & sDate & " and MStartWorkTime <=" edate & "

[海大富运动]

效果还是不行！我希望检索7号到13号的记录，结果：全部检索出来；检索2号到13号记录，只出来13号一天的记录

数据库记录：6号到13号的数据，每天各一条

[海大富运动]

up