Date type mismatch in criteria expression

[ahmed sami]

I have a query that is based on another query, in its criteria i have already put the following sql statement:


Between DateAdd("m",-10,Now()) And DateAdd("m",10,Now())
such that once run, it displays only dates that fall in this range. It was Ok for long time, but with out a specific reason it started to display the following message:
Date type mismatch in criteria expression, then turns every thing to #Name
Any help with be great. Thanks.

[pbaldy]

Is it possible there's a Null in the date field?

[John_G]

The error may not be in the "Between" - it may be in some other part of the expression.

Can you post the complete SQL of the query?