Dim rq2 As Date
rq2 = Format(Now, "YYYY-MM-DD")
a_Sql = "Select * From tLogs where format(dtTime1,'yyyy-mm-dd')='" & rq2 & "'"
这样没有错误提示!但是还是查不到数据
MsgBox (rsa.RecordCount)是0
a_Sql = "Select * From tLogs where dtTime1 >= '" & Format(Now, "YYYY-M-D") & "' AND dtTime1 < '" & Format(DateAdd("d", 1, Now), "yyyy-M-d") & "'"
这样的显示实时错误 '-2147217913 (80040e07)'
标准表达式中数据类型不匹配
数据库是access库
Dim rq2 As Date
rq2 = Format(Now, "YYYY-MM-DD")
a_Sql = "Select * From tLogs where convert(char(10),cast(dtTime1 as datetime),120)='" & rq2 & "'"
这样不行啊!
提示错误:实时错误'-2147467259 (80004005)'
对象'Open'的方法'_Recordset'失败