Dateformat

[Christopher Brandsdal]

I'm turning green on this!!
What I need to do is insert a date from a textfield by using
rsFakt("DomeneDato") = Request.Form("DatoDomene")
I just get this error:


Provider error '80020005'

Type mismatch.

/Server_ny.asp, line 344



The database-field is set up with date/time. I use access.
I havd tryed this:

rsFakt("DomeneDato") = Now()

rsFakt("DomeneDato") = FormatDateTime(Now(), 0)

These ones should return the same???
The first one works, but the secound one returns the same error. WHY? How
can I format the string so that the database can take it?

 

[Danny@Kendal]

I'm turning green on this!!
What I need to do is insert a date from a textfield by using
rsFakt("DomeneDato") = Request.Form("DatoDomene")
I just get this error:


Provider error '80020005'

Type mismatch.

You need to match the data types.

Does this work for you?
rsFakt("DomeneDato") = CDate(Request.Form("DatoDomene"))

 

[Christopher Brandsdal]

Thanks! worked great Just another tuesday morning hehe..