Hi Friend,

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

Error:
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

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

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.