Operator must be followed by any or all

[Crystalguru]

I have this, what I believe, is a simple query. But, it is giving me the error, operator must be followed by any or all. I am not sure WHICH operator it is talking about.

select
PROPERTY_REGION,
count(property_id)
FROM
COMMUNITIES
WHERE
PROPERTY_REGION = 'Dallas' and
PROPERTY_EFF_DATE<=to_date('01-JAN-2002','DD-MM-YYYY') and
PROPERTY_EXP_DATE IS NULL or PROPERTY_EXP_DATE>('31-DEC-2003','DD-MM-YYYY')
Group by
PROPERTY_REGION

Any ideas are appreciated!

 

[swampBoogie]

select
PROPERTY_REGION,
count(property_id)
FROM
COMMUNITIES
WHERE
PROPERTY_REGION = 'Dallas' and
PROPERTY_EFF_DATE<=to_date('01-JAN-2002','DD-MM-YYYY') and
(PROPERTY_EXP_DATE IS NULL or PROPERTY_EXP_DATE> to_date('31-DEC-2003','DD-MM-YYYY'))
Group by
PROPERTY_REGION

 

[Crystalguru]

Ah what sweet relief that was! Thank you so much! It worked, just a little ole to_date....