dato/tid

Kode:
<% if mode = "opret" then
    Tidspunkt = DateTime
    Overksrift = Request.Form("overskrift")
    Problem = Request.Form("problem")

if request.form("lost") <> "" then
check_lost = 1
    Losttid = DateTime
else
check_lost = 0
end if

Overskrift = Replace(overskrift,"'","''")
Problem = replace(Problem, chr(13), "<BR>")
Problem = Replace(Problem,"'","''")

%>



<!--#include file="dbconnection.inc"-->
<%
SQLstmt="INSERT INTO Driftstatus (Tidspunkt, Overskrift, Problem, Losttid) Values('"&Tidspunkt&"','"&Overskrift&"','"&Problem&"','"&Losttid&"')"
'response.write sqlstmt

Conn.Execute (SQLstmt)

conn.Close
Set conn = nothing
Set SQLstmt = nothing
response.redirect ("eAdmin.asp")

end if
%>
---
Jeg får flg. fejl:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/esupport/OpretDriftstatus.asp, line 105

----
datofelter i DB er sat til Date/time - General Date