How to update current date and time in an databasefield

[leifoet]

I update certain database fields with an ado connection
Set adoCon = Server.CreateObject("ADODB.Connection")
...
'Update the record in the recordset
rsUpdateEntry.Fields("Stts1") = Request.Form("Stts1")
rsUpdateEntry.Fields("Stts2") = Request.Form("Stts2")
That works fine.

Now I added the fields 'date' and 'time' to the (Access)database.
I want to update these fields with the (user-system) date and time - The update code below does not work

rsUpdateEntry.Fields("Dateact") = date()
rsUpdateEntry.Fields("Timeact") = time()

Thanks for help.

 

[leifoet]

Problem solved - I typed a typo in a field - sorry