hello all
i'm using vb2005.
in one of the forms i'm using the filter method of the bindingsource
i've used it before, but not on a date field.
now, any comparison i try produces an error (things like):
If tpToDate.Checked Then
strFilter = "[chqCashDate]<=" & dtDate.Value
ElseIf tpOnDate.Checked Then
strFilter = "[chqCashDate]=" & dtDate.Value

in this example, dtDate is a datetimepicker, tpToDate is a radio button, and
chqCashDate is a smalldatetime field in a sql db table

the error says something about invalid use of "=" operator.
can someone please guide me in the right way?

thanx in advance
Erez.

Hi,

You might take a look at DataColumn.Expression .net help topic on how to
deal with date formats.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Erez Mor" <ErezMor (AT) discussions (DOT) microsoft.com> wrote