I am trying to insert a date into a table in my database
from a form. I am using sql server 7.0. The problem is
that when the date goes into the table it always changes
to the date 1/1/1900.
I am using the datatype 'date' in my front-end. When i
pass the variable into my sql statement it is the correct
date but when i view it in the databse it has changed.
But when i enter the date into the database directly and
then view it on the form it is the correct date.
Am i using the wrong datatype in my database or in VB?

I don't think you use wrong datd type. You can stop the program before the
SQL statement was excuted, and check the exact value SQL string. If you use
like:

Conn.execute strSQL+"1/1/2002"

or Conn.execute strSQL+MyDate

You can change it to

Dim SQLString as String

SQLString=strSQL+MyDate

conn.Execute SQLString

Then check the exact value of SQLString. Also you can paste the string into
SQL Query Analyzer and execute it for test.

Luke

(This posting is provided "AS IS", with no warranties, and confers no
rights.)