How can I do a select on a dataset table with the "Right" function on a string ?
Problem now is that the "Right" function is not usable in the rowfilter or a .Select()
ds.Tables("Overview").DefaultView.RowFilter = "right([Dates],4 = " & dat_year
The table in the dataset ds contains the column Dates in which text is stored like :
"01.01.2005 - 01.02.2005" and I would like to do a select on the last 4 char.