Apex Code Development You need to sign in to do that
Don't have an account?
mamidi mahesh How to add integer number 1 to date type variable todayDate in soql query(query='select id,Status__c from position__c where Status__c=\'Closed\' and createdDate<=:(todayDate)+1';)
global class ClosePosEveryDay implements database.Batchable<sObject>{
global database.QueryLocator start(database.BatchableContext bc){
String query;
date todayDate=date.today();
System.debug('Today Date------------->'+todayDate);
System.debug('System Date------------->'+System.today());
query='select id,Status__c from position__c where Status__c=\'Closed\' and createdDate<=:(todayDate)+1';
System.debug('Query------------->'+query);
return Database.getQueryLocator(query);
}
global void execute(database.BatchableContext bc, List<position__c> scope){
System.debug('Scope------------->'+scope);
for(position__c posRec:scope){
posRec.Status__c='Closed';
}
Database.update(scope,false);
}
global void finish(database.BatchableContext bc){
}
}
please give me valid answer for this.
global database.QueryLocator start(database.BatchableContext bc){
String query;
date todayDate=date.today();
System.debug('Today Date------------->'+todayDate);
System.debug('System Date------------->'+System.today());
query='select id,Status__c from position__c where Status__c=\'Closed\' and createdDate<=:(todayDate)+1';
System.debug('Query------------->'+query);
return Database.getQueryLocator(query);
}
global void execute(database.BatchableContext bc, List<position__c> scope){
System.debug('Scope------------->'+scope);
for(position__c posRec:scope){
posRec.Status__c='Closed';
}
Database.update(scope,false);
}
global void finish(database.BatchableContext bc){
}
}
please give me valid answer for this.
Try calculating you date before your query :
date MyDate=date.today();
MyDate = todayDate.addDays(1);
and then use MyDate in your query.
regards,
jerome
Fred