I have SQL on Access database like this:

insert into customer (id, name, date) values (12,'Max', #12/12/1999#)

Actually I have more complicated SQL string but my problem is here.

With this SQL string I want to insert record with date is null. So I generate next sql sentence:

insert into customer (id, name, date) values (12,'Max', ##) which (of course) return error.

What should I do?

Thnx, Ermin