Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Vadivel MuruganVadivel Murugan 

Date for Same month

Hi All,

I have query last 90days record for opportuniy. I need to put monthwise record in map. For exmaple.

opportunity Created date - 12-12-2015
Opportunity Created date - 03-01-2016

The above opportunity stored in different maps. how to store it in maps. Any one know please reply to me.
pconpcon
So you are looking to create a map of opportunity month to list of opportunities?
  
Map<Integer, List<Opportunity>> oppMap = new Map<Integer, List<Opportunity>>();

for (Opportunity opp : [
    select CreatedDate
    from Opportunity
    where CreatedDate = LAST_N_DAYS:90
]) {
    Integer month = opp.createdDate.month();

    if (!oppMap.containsKey(month)) {
        oppMap.put(month, new List<Opportunity>());
    }

    oppMap.get(month).add(opp);
}
NOTE: This code has not been tested and may contain typographical or logical errors