You need to sign in to do that
Don't have an account?
jayesh pagare
how do I get opportunity close date is two year ago in soql query?
below are two working query for getting close date on current and last fiscal year..but i want a query to get opportunity having close date two years before something like: (CloseDate = LAST_FISCAL_YEAR-1)
1] [SELECT SUM(Amount),AccountId FROM opportunity where AccountId IN :AccountIDsAND CloseDate=LAST_FISCAL_YEAR GROUP BY AccountId]
2] [SELECT SUM(Amount),AccountId FROM opportunity where AccountId IN :AccountIDsAND CloseDate=THIS_FISCAL_YEAR GROUP BY AccountId]
1] [SELECT SUM(Amount),AccountId FROM opportunity where AccountId IN :AccountIDsAND CloseDate=LAST_FISCAL_YEAR GROUP BY AccountId]
2] [SELECT SUM(Amount),AccountId FROM opportunity where AccountId IN :AccountIDsAND CloseDate=THIS_FISCAL_YEAR GROUP BY AccountId]
Agustina
All Answers
Check this link it may helps
Agustina