DataView Date FIltering Problem

[asifmaniar]

Hi, I am trying to filter data from a dataview based on a date column. The problem is that I need to be able to compare just the day and month part of the date. I can't seem to figure it out. Code: I tried both the following filters but convert, ctype etc are unrecognized in the dataview. Any suggestions will be appreciated. Dim filter As String = "ListingID = '{0}' And convert.ToDateTime(StartDate).Day = '{1}' And convert.ToDateTime(StartDate).Month = '{2}'" view.RowFilter = String.Format(filter, ListingID, StartDate.Day, StartDate.Month) OR Dim filter As String = "ListingID = '{0}' And " & CType(view.Table.Columns("StartDate").ToString, DateTime).Day() & " = '" & StartDate.Day & "'"

[Mike Ellison]

Hi there. The expressions available for the DataView.RowFilter property are explained in the documentation for DataColumn.Expression[^]. It's pretty limited. There aren't any date-specific functions I'm aware of, and you can only use CONVERT on a DateTime to change the type to a String. But with that, I'm thinking you may be able to use a combination of CONVERT and SUBSTRING to accomplish what you want. Maybe something like this (untested):

Dim filter As String = "ListingID = '{0}' And " _
& "Substring(Convert(StartDate, System.String), 1, 5) = '{1}'"

view.RowFilter = String.Format(filter, ListingID, StartDate.ToString("MM/dd"))

I'm making the assumption here that the CONVERT expression function would return a date in the format "MM/dd/yyyy", which I'm not sure of. But maybe some permutation of this idea will help.