Format Time Field

[dvannoy]

I am inserting records from VB into a sql200 server. in one of my text boxes i have the time.
it shows up on the form as a normal time eg.. 3:20:00 PM

but when I insert the record into the table it shows up as 1/19/1900 3:20:00 PM...how can i get rid of this??

 

[JoeCool71]

How is your field set up on your SQL table? I would start there. When you receive a 1/1/1900 date field, your table is set up using a normal date format and is converting a none date into a date it can use (1/1/1900).

 

[dvannoy]

Yes, it is a datetime field on the server..is that correct or what? I am doing the same thing in another form but the only difference is on the other form I am doing rs.addnew.
And that works no problem. but the problem seems to be related to an INSERT statement into the table.