I am trying to avoid a data mismatch for my query. The portion of the query (query2) causing the problem is:
SELECT Date()-[caAssignmentDate] AS AsgnAge
FROM Query1
WHERE (((Date()-[caAssignmentDate])>10));
If I remove the WHERE portion, it works fine. If I remove the null records from the...