Member Avatar for Parth_3

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

  • 3 Contributors
  • 2 Replies
  • 272 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by Phoguez
Member Avatar for pritaeas

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

Member Avatar for Phoguez

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.