This:
Code:
var table = data.TABS_Quantities.Where(i => i.BusinessDate >= DateTime.Now.AddDays(-2) && i.BusinessDate <= DateTime.Now.AddDays(-1));
returns the same as this:
Code:
var table = data.TABS_Quantities.Where(i => i.BusinessDate == DateTime.Now.AddDays(-1));
What I actually want is to return the last 7 days, but in order to do that, I have to do this:
Code:
var table = data.TABS_Quantities.Where(i => i.BusinessDate >= DateTime.Now.AddDays(-8) && i.BusinessDate <= DateTime.Now.AddDays(-1));
it should be "-7", right?? Instead of "-8"... If it's my operands, please fill me in. I must just be having a bad day, because this has my brain in a whirlwind... Thanks!