Dato format

"'" &  Date() & " 23:23:23'"

maybe

or maybe

insert into Testtable values (
'test', Cdate(Date() & " 23:23:23"))

Nope.

07001(-3010)[Microsoft][ODBC Microsoft Access-driver] Der er for få parametre. Der var ventet 1. (0,00 secs)

"INSERT into tblDato (dato) Values('" & CDate(Date() & " 23:23:23") & "')"

the above SQL works so

"INSERT into Testtable Values( 'test', '" & CDate(Date() & " 23:23:23") & "')"

cant be far out

unless you have another field in the table, in that case you must either include it, or include a field list.

Ah ya, got it to work,
one problem tho,
I get DD-MM-YYYY and i need YYYY-MM-DD

if the field in the database is a date/time field then they way the date+time is stored is not the same as how you see it.
The PC's regional settings decide how the value is displayed.

If the field is a text then try

"INSERT into Testtable Values( 'test', '" & Format(Date(), "yyyy-mm-dd") & " 23:23:23") & "')"

STAUS DAMON?

damon, can we close here please?