Query error

[Nathan]

I am trying to run a query which compares a list of dates
with the current date in order to filter them into valid
dates only. The criteria I am using is: < Date()
I have used this before and it has worked but now it
brings up the error:
This expression is typed incorrectly, or it is too complex
to be evaluated. For example, a numeric expression may
contain too many complicated elements. Try simplifying the
expression by assigning parts of the expression to
variables. (Error 3071)

Any help would be appreciated

 

[[MVP] S. Clark]

Post the SQL.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Nathan]

SELECT CON.Name, CON.[CIS Status], CON.[CIS Expiry Date],
CON.Approved, CON.Comments
FROM CON
WHERE (((CON.[CIS Expiry Date])>Date()));