Error conversion charactar to datetime data type

[Jonid]

i get an error everytime i insert date data in my vb component and sql server bakend. an example is shown below


Sql = "insert into trans"
Sql = Sql & " values("

...
Sql = Sql & "'" & date() & "'" & &quot"
...
cn.execute sql

error message: error conversion char... to datatime data type.

where my date field is datatime data type.

 

[JohnYingling]

In regular VB I use NOW().

http://WWW.VBCompare.Com

 

[Jonid]

i get same error using now and even getting date from other recordset.
error converting datetime data from char or text data

 

[Bastien]

hi
SQL Server will provide its own date and time...

insert into trans values(sysdate)
--check the syntax to be sure...it should be some variation of that...

which takes the system date and places it into the DB

bastien