I got a problem, i am using VB 6 to write a DB app and it connects to a SQL server 6.5, in the database two fields, TimeLogged and DateLogged are both datetime datatypes. In VB my date and times to add to the database are both strings.

How can i get SQL server 6.5 to add them to the record( by converting them to datatime????) Please Help