DateFormat To Insert Into Access

[Francois]

Hallo

I have a problem with the format that i insert a DateTime in a table.

I need to enter a date and time into a table has a field set data type is Date/Time. How how do i enter the current date into that table, how do I change the format???!!! I Tried Date.Now, Date.Today, DateAndTime.Now, DateAndTime.Today, None works!!! Please help!

Thanx

 

[lingsn]

If you are using the sql, it is something like this:

INSERT INTO TABLE (dtColumn) VALUES (#01/01/2006#)

 

[Raven65]

Like lingsn hinted at, if your inserting this via code you have to let the database know your passing a date type object.

You likely have a SQL statement your building like:

sqlCommand = "INSERT INTO [table name] (columnname) VALUES (datevariable)"

What you'll want to add is along the lines of:

sqlCommand = "INSERT INTO [table name] (columnname) VALUES (#" & datevariable & "#)"