SOQL 日付関数サンプル

TerraSkyTechBlog20130417_006

AggregateResult[] results = [SELECT FISCAL_YEAR(CloseDate) year,
                                    SUM(Amount) summary 
                               FROM Opportunity 
                              WHERE IsWon = true 
                              GROUP BY FISCAL_YEAR(CloseDate)];
for(AggregateResult ar: results){
  System.debug('年度='+ ar.get('year') 
           + '：金額='+ ar.get('summary'));

}