Linq where dates question

[Member 7818892]

Hi folks This expression works fine without the where clause: var someQuery = from some in context.OGsome where ((some.Due_Date >= some.Base_Date.Value.AddDays(-70)) && (some.Due_Date <= some.Base_Date.Value.AddDays(+70)) ) select some; I am trying to limit the query to between +/- 70 days. I keep getting an exception. Many thanks for any help resolving this. Mike

[Pete OHanlon]

What is the exception?

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

[BobJanova]

Is that column a DATETIME in the database? Is some.Base_Date something which can be known at the time the expression is compiled into a SQL query? Try storing the bounds in local variables.

[Matt T Heffron]

So it appears that Due_Date and Base_Date are both columns in the DB (properties in the Entity object?) Why do you use the .Value property with Base_Date and not with Due_Date? Are they both Nullable? What happens if either is null? (An exception? hint, hint)

[Matt T Heffron]

So...did it get solved?