Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
evan34evan34 

Date Check in a batch apex

Hi All,

 

 I have written a query in a batch apex. It was working correctlt until i added

 Date_Opened__c>(today -(5*Average_Sales_Cycle__c)).   It is giving an error  "First error: unexpected token: '(' " when i run the batch apex.

 

Please let me know what is the right way to query a date field (Date_Opened__c) which meet the above criteria.



 

q= 'Select id, name,StageVFlag__c, StageBFlag__c,StageAFlag__c,StageEFlag__c,StageCFlag__c,StageGFlag__c,ownerid, status__c, type, amount,  from opportunity where  (amount>=0.00 and amount<=100000.00) and Date_Opened__c>(today -(5*Average_Sales_Cycle__c)) and type =\'Non-Recurring\'';}

 

Thanks

bob_buzzardbob_buzzard

I'd say that this is because you are attempting to use a field on the right hand side of the field comparison.  According to the docs:

 

--- snip ---

 

You must supply a native value—other field names or calculations are not permitted

 

--- snip ---

 

I've worked around this kind of thing by creating a formula field that encapsulates the condition, and I just then query all records where the formula evaluates to true.
atulajawaleatulajawale

HI ,

 

I guess you need to use a date variable  & use it in Query.

 

Steps should like

 

1.take a integer variable to store your calculation say numDay  = (5*Average_Sales_Cycle__c).

2. create a date variable initialise to today say Date tod = Date.today();

3. Now create one more variable Date beforeDate  = tod.addDays(-numDay);

3. Now use this beforeDate in Query like

 

q= 'Select id, name,StageVFlag__c, StageBFlag__c,StageAFlag__c,StageEFlag__c,StageCFl​ag__c,StageGFlag__c,ownerid, status__c, type, amount,  from opportunity where  (amount>=0.00 and amount<=100000.00) and Date_Opened__c>:beforeDate and type =\'Non-Recurring\'';}

 

Let me know if this works ...