"Could not convert variant of type (String) into type (Date)" on Insert

clear DefaultValue property for your datDateTime field. looks like it has Now value.