Need some help on a query, I don't want to change query significantly. I am trying to list only records that do not have a statusid of 10. Also I do not want to list records that have a statusid of 17 where modifieddate is more than 6 months past. How to do this? The following query does not work the way I want it to.
var q = from tList in targetList
where (tList.Status.StatusID != 10) && (tList.Status.StatusID != 17 && tList.Modified > date6MonthsPast)