I am trying to query all the opportunities which are having a date field xyz which stores the current date + 1 week in current quarter. But my issue is I am not able to reduce (-7) days in SOQL query dynamically. Can someone suggest me. I don't want to add for loop and map to increase processing time.
I am trying something like this
select Id, abc__c from opportunity where xyz.addDays(-7)=THIS_QUARTER