Gridview filtered expression date

ShaePNC
ShaePNC used Ask the Experts™
on
I am trying to search by a date in a gridview using asp in vb2010. My webpage displays, but when I try to seach using my date criteria it generates an error message.  Attached is the code I have entered. Please let me know if you see where I am doing something wrong. I am given the following error noted (in the attached code) when attempting to search any field. All search function works as advertised.  I just need to figure out how to add a
search function to return the [DateDue] parameter.

Any help they can give me would be greatly appreciated

ShaePNC
code1.docx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Commented:
You would need to convert dateDue to varchar

Instead of

DateDue Like '%4%'

use

Convert(Varchar, DateDue, 103) Like '%4%'

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial