Hi All,
I am trying to filter a dataview by a user defined date...
When I attempt this I get the following error:
"Cannot perform '<' operation on System.DateTime and System.Double."
Here is my code:
Private Sub btnFilter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFilter.Click
Dim SelectedDate As System.DateTime
SelectedDate = txtSelectedDate.Text
DV.RowFilter = "[Start_Date] < " & SelectedDate & " AND [End_Date] > " & SelectedDate
DataList.DataSource = DV
End Sub
Anyone know what I am doing wrong?
I am trying to filter a dataview by a user defined date...
When I attempt this I get the following error:
"Cannot perform '<' operation on System.DateTime and System.Double."
Here is my code:
Private Sub btnFilter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFilter.Click
Dim SelectedDate As System.DateTime
SelectedDate = txtSelectedDate.Text
DV.RowFilter = "[Start_Date] < " & SelectedDate & " AND [End_Date] > " & SelectedDate
DataList.DataSource = DV
End Sub
Anyone know what I am doing wrong?