ASP問題
 

在時間的地方出現問題..有大大能幫忙解決嗎?
謝謝
錯誤類型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 查詢運算式 '[通知時間]=#上午10:33:00# AND [病歷姓名]=''' 中的 日期語法錯誤。
/send.asp, line 11
<%
time1=left(time,2)
hour1=hour(time)
minute1=Minute(time)
btime=time1 & "" & hour1 & ":" & minute1 & ":" & "00"

response.write btime
Set Conn =server.createobject("Adodb.Connection")
Conn.Open "Driver={Microsoft Access Driver (*.mdb)};Pwd=;Dbq=" & Server.Mappath("User2.mdb")
Set Rs = Server.CreateObject("adodb.recordset")
Rs.open "select * from [預約資料] where [通知時間]=#"& btime &"# AND [病歷姓名]='" & Session("UserNm") &"'" ,conn,1,3
if rs.EOF =true then
response.write "無發送email"
else
Set Rs2 = Server.CreateObject("adodb.recordset")
Rs2.open "select * from [基本資料] where [姓名]='" & Session("UserNm") &"'",conn,1,3
email=rs2("email")
response.write email
end if
rs.clone
Set conn=nothing
rs2.clone
set conn=nothing
%>