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.

Be a part of the DaniWeb community

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