INSERT INTO with date fields

[tylerg11]

Hello,



I have an insert into statement this involves inserting values into date/time fields. I understand the a '#' has to come before and after the value, and when all values are populated this works great.

INSERT INTO TableName VALUES (#1/1/2013#,#1/2/2013#)

However, what about in the case of Nulls? The resulting statement then looks like the following. This results in the statement trying to put a '##' in the table and it doesn't like it.

INSERT INTO TableName VALUES (#1/1/2013#,##)

I am trying to input records into a local Access table, not a SQL table.

Thanks!

[amrut]

Use null instead of ##.

INSERT INTO TableName VALUES (#1/1/2013#,Null)