I have a xml file I load into a data set. One of the fields ends up being a string date value of
This is the value it uses for a null value. Anyway I need to create a rowfilter to see if the first 4 characters are "1900"
ds.tables(0).defaultview.rowfilter = "?????"
Normally I would go "Completedby = '" & ds.tables(0).rows(i).item(2).tostring" and I would be good to go, but what I need to do is something like "left(completedby,4)='1900', but when I do that it doesnt seem to get column information correct. Any ideas, thanks