Hi,

I have to write a scheduled job to find out the opportunity created past 7 days and assign it to another set of owners.

when i tried the below code, i am getting some issues with createddate on SOQL.

below is my code,

Set<Opportunity> setopp = new Set<Opportunity>();
Map<ID,ID> mapFinalOutputOpp = new Map<ID,ID>();
Map<Id,String[]> mapOppInputs = new Map<ID,String[]>();
String AgentIds = Label.Agent_name_for_rerouting;
List<String> StrAgentIDLst= AgentIds.split(',', 5);
system.debug('agent lst'+StrAgentIDLst);
List<String> AgentIDLst = new list<String>();
// getting the strings from the label
for(String s:StrAgentIDLst){
system.debug('individual agent lst'+s);
//String AgentID = Id.valueOf(s);
AgentIDLst.add(s);
}
//fetching the opportunity
date d = system.today().addDays(-7);
system.debug('system date - 7'+d);
date d2 = system.today().addDays(-8);
system.debug('system date - 7'+d2);
for (String Ids:AgentIDLst){
List<Opportunity> lstopp = [Select ID, Inquiry_School__c,LeadSource,CampaignId,Inquiry_Degree__c from Opportunity where Owner.name =:Ids and CreatedDate >: d2 and CreatedDate <: d and StageName = 'Lead'];
setopp.addAll(lstopp);
lstopp=null;
}
system.debug('setopp size'+setopp.size());
system.debug('lstopp'+setopp );

Please let me know.