While still trying to learn some basic LINQ, I seem to run into "difficult" cases all the time.
I want to filter my data in a DataTable to show only the rows where a certain date field is NOT NULL (well, that would be what I would look for with Oracle SQL)
Once I get the not null query working, I want to expand to showing only the dates in a given quarter, so any hint on that would be extremely valuable as well.
The code shows my last effort but now I had to give up in solving this myself
Thanks a lot!
caseOwnerQuery = "";
caseOwnerQuery = supportSpecialist.Text;
IEnumerable<DataRow> filtered = (from data in _fullTable.AsEnumerable()
where data.Field<string>("Case Owner") == caseOwnerQuery
&& data.Field<DateTime>("Case Open Date") != Convert.DBNull