Run-time error '-2147217913(80040e07)';
[Microoft][SQL Native Client][SQL Server]Conversion failed when converting character string to smalldatetime datatype.

New to coding..could anyhelp help please...thanx

It is virtually impossible to analyse this without you posting the actual statement that raised the error.
It is further helpful to provide some context, such as the value of the variables that the error-producing
statement uses, how the user got there, whether the statement is in a form's module, a class module, or a
code module, and so on.

Thanks brian as iam not getting this error on the system now ,i think i might have solved it somehow i dont know...lol u can see the code which i was using in the other post u answered..still need help thanks a bunch..

For lurkers, that "other post" is http://p2p.wrox.com/topic.asp?TOPIC_ID=48728

OK, well, good! (Always good to hear a problem's solved...

But still, the guidelines I spelled out above would appy to any and all posts.