Hi Friend,

dtpdate datetime 
that's my field and datatype 
in vb.net use dtpdate.text

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.

please solve my problem.

Thanks & Regards

Re: sql , vb.net 80 80

Without any code it's hard to say, but shouldn't you be using dtpDate.Value?

Re: sql , vb.net 80 80

Dim dpDate As DateTime = Now()

MsgBox("The date is " & dpDate)

Select * FROM Invoice where InvoiceDate = dpDate

You cannot store a Char datatype to a datetime type.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.