RowFilter?

[Able]

Dear friends

Do somebody see what is wrong with this?:

myDataView.RowFilter = "fldDate Is Not Null And fldDate<" &
System.DateTime.Today

Regards Able

 

[Jay B. Harlow [MVP - Outlook]]

Able,
You need to enclose the date in pound signs "#".

Try something like:

Const format As String = "fldDate Is Not Null And fldDate < #{0:d}#"

myDataView.RowFilter = String.Format(format,System.DateTime.Today)

The syntax that ADO.NET supports for Expressions (such as those passed to
Select & Compute) is documented under DataColumn.Expression.

http://msdn.microsoft.com/library/d...fSystemDataDataColumnClassExpressionTopic.asp

Hope this helps
Jay