This users on this site have great brain power.  I understand that there is also one further consideration.  there is a restrain on datetime - before 1753? and after 9999?  Would...

Dang I don't think that you can take two character type fields i.e. date and time and come up with a datetime data type.  You can concatenate the two aforementioned columns...