chuckster1
MIS
I'm sure my simple SQL statements worked before but now I'm getting a type convertion error.
The ERROR:
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value"
Code: 80040e07
I tried Cdate(now())
And
myDate = now()
Isdate(myDate) Returns true but if I put myDate in the strSQL it gives the same error.
STATEMENT 1:
strSQL = "UPDATE storeduseraccess SET item = 'I Do not Accept this Policy', loggeddatetime = '" & now() & "' WHERE NTusername = '" & myUsername & "'"
STATEMENT 2:
strSQL = "UPDATE storeduseraccess SET item = 'I Do not Accept this Policy', loggeddatetime = '" & now() & "' WHERE NTusername = '" & myUsername & "'"
The Error occurs with either statement.
Could the problem be with SQL 2000? The field is a datetime datatype.
Hope you can help.
Chuckster.
The ERROR:
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value"
Code: 80040e07
I tried Cdate(now())
And
myDate = now()
Isdate(myDate) Returns true but if I put myDate in the strSQL it gives the same error.
STATEMENT 1:
strSQL = "UPDATE storeduseraccess SET item = 'I Do not Accept this Policy', loggeddatetime = '" & now() & "' WHERE NTusername = '" & myUsername & "'"
STATEMENT 2:
strSQL = "UPDATE storeduseraccess SET item = 'I Do not Accept this Policy', loggeddatetime = '" & now() & "' WHERE NTusername = '" & myUsername & "'"
The Error occurs with either statement.
Could the problem be with SQL 2000? The field is a datetime datatype.
Hope you can help.
Chuckster.