Date Datatype problem on insert and update

[LLudlow]

I am trying to save a date from a VB 6.0 form to a SQL server database. The datatype for the form is Date and the datatype for the Database is datetime. When i try to save the date to the database it becomes 1/1/1900. But the appropriate variable in the sql statement is showing the correct date but when it is entered into the table it gets changed. But in reverse if i enter the dat into the database then it displays correctly on the form. Am i doing something wrong with the datatypes?

Thanks

 

[LLudlow]

I know what the problem is but i do not know how to fix it.
When i am inserting into the table there has to be quotes around the date so in my sql goes something like this:

chr(39) & date & chr(39)

this works fine when there is a real date in the textbox but when it is empty i try to pass Null as the value but when this is inserted into the SQL statement it is turned into "Null" which is not accepted by the database. So instead the field in the database becomes 1/1/1900.

Does anyone know a simple way to resolve this?

Thanks in advance