I have a date column that I want to apply a filter to (using the dataview rowfilter). My problem is that I need to filter it by just the Year of that column, not the whole date.
Something like this is what I am currently working with:
Dim dv As New DataView(ds.Tables(0))
dv.RowFilter = "Year(payment_date) = " & text1.text.trim
GridView1.DataSource = dv
This gives me the error: The expression contains undefined function call Year().
Is there a way to do this without altering the dataset possibly using date functions?