Hi,
I am trying to insert Null value in column(ShipDate) in my table.That
column(ShipDate)'s type id date/time and format is short date.

I am using   ""   to insert Null in that column(ShipDate) but it shows
warning that
customer can't append all the records in the append query.
Customer set 1 field(s) to Null due to a type conersion failure,and it
didn't add 0 record(s) to the table due to key violation, 0 record(s)
due to lock violations, and 0 record(s) due to validation rule
violations.
Do you want to run the action query anyway?

But still if I click on Yes than it will simply execute the query and
insert null value in table.
And if I click on No than it cancel the execution of query.

its caused just because i set type as date/time and put format as
short date in that column(ShipDate) in my table.

How can I remove this warning?