I am getting parsing error is below query:
select id, name, Excercising__c, opportunity__r.id, opportunity__r.Contract.Status from option__C where opportunity__r.Contract.status__c='current' AND Excercising__c ='No' AND ( Option_to_Renew_First_Date__c =system.today()+180 OR Market_Review_First_Date_Landlord__c=system.today()+180 OR Excercise_Start_Date__c =system.today()+180 OR Market_Review_First_Date_Tenant__c= system.today()+180 )
can someone please help me out of this? I am getting parsing error in code between the () as I checked after removing them and it is working as expected. Kindly help.