Apex Code Development You need to sign in to do that
Don't have an account?
Name of Months within the start and end dates
Hi,
PS: I am preparing a design so no code is written so far.
In my custom object, I store the start and end dates of a particular campaign, let's say start date is 01/01/2017, the end date is 03/31/2018. For these 15 months, I need to create an opportunity (one for each month) and need to mark the close date as the end date of every month. This process of Opportunity creation is going to happen through a trigger.
I would like to check if anyone has done something similar to this and can share a code snippet or provide the best practices around this.
Thanks.
PS: I am preparing a design so no code is written so far.
In my custom object, I store the start and end dates of a particular campaign, let's say start date is 01/01/2017, the end date is 03/31/2018. For these 15 months, I need to create an opportunity (one for each month) and need to mark the close date as the end date of every month. This process of Opportunity creation is going to happen through a trigger.
I would like to check if anyone has done something similar to this and can share a code snippet or provide the best practices around this.
Thanks.
Map<Integer, String> mapOfMonthNameByMonthNumber = new Map<Integer, String>(); // There's probably a more elegant way to do this... mapOfMonthNameByMonthNumber.put(1, 'January'); mapOfMonthNameByMonthNumber.put(2, 'February'); mapOfMonthNameByMonthNumber.put(3, 'March'); mapOfMonthNameByMonthNumber.put(4, 'April'); mapOfMonthNameByMonthNumber.put(5, 'May'); mapOfMonthNameByMonthNumber.put(6, 'June'); mapOfMonthNameByMonthNumber.put(7, 'July'); mapOfMonthNameByMonthNumber.put(8, 'August'); mapOfMonthNameByMonthNumber.put(9, 'September'); mapOfMonthNameByMonthNumber.put(10, 'October'); mapOfMonthNameByMonthNumber.put(11, 'November'); mapOfMonthNameByMonthNumber.put(12, 'December'); Integer oppsToCreate = Campaign.StartDate.monthsBetween(Campaign.EndDate) + 1 // Need to add 1 to account for the end date month List<Opportunity> oList = new List<Opportunity>(); for(Integer i = 0; i < oppsToCreate; i++){ Date closeDateToUse = Campaign.StartDate.addMonths(i+1).toStartOfMonth -1 // Start date of 12/16/2017 becomes 1/1/2018 - 1 day = 12/31/2017 Opportunity o = new Opportunity( CloseDate = closeDateToUse, Month_Name_Field = mapOfMonthNameByMonthNumber.get(closeDateToUse.month()), ...other fields... ); oList.add(o); } insert oList;All Answers
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_methods_system_date.htm
Something like this should get you started:
Integer oppsToCreate = Campaign.StartDate.monthsBetween(Campaign.EndDate) + 1 // Need to add 1 to account for the end date month List<Opportunity> oList = new List<Opportunity>(); for(Integer i = 0; i < oppsToCreate; i++){ Opportunity o = new Opportunity( ... CloseDate = Campaign.StartDate.addMonths(i+1).toStartOfMonth -1 // Start date of 12/16/2017 becomes 1/1/2018 - 1 day = 12/31/2017 ); oList.add(o); } insert oList;Map<Integer, String> mapOfMonthNameByMonthNumber = new Map<Integer, String>(); // There's probably a more elegant way to do this... mapOfMonthNameByMonthNumber.put(1, 'January'); mapOfMonthNameByMonthNumber.put(2, 'February'); mapOfMonthNameByMonthNumber.put(3, 'March'); mapOfMonthNameByMonthNumber.put(4, 'April'); mapOfMonthNameByMonthNumber.put(5, 'May'); mapOfMonthNameByMonthNumber.put(6, 'June'); mapOfMonthNameByMonthNumber.put(7, 'July'); mapOfMonthNameByMonthNumber.put(8, 'August'); mapOfMonthNameByMonthNumber.put(9, 'September'); mapOfMonthNameByMonthNumber.put(10, 'October'); mapOfMonthNameByMonthNumber.put(11, 'November'); mapOfMonthNameByMonthNumber.put(12, 'December'); Integer oppsToCreate = Campaign.StartDate.monthsBetween(Campaign.EndDate) + 1 // Need to add 1 to account for the end date month List<Opportunity> oList = new List<Opportunity>(); for(Integer i = 0; i < oppsToCreate; i++){ Date closeDateToUse = Campaign.StartDate.addMonths(i+1).toStartOfMonth -1 // Start date of 12/16/2017 becomes 1/1/2018 - 1 day = 12/31/2017 Opportunity o = new Opportunity( CloseDate = closeDateToUse, Month_Name_Field = mapOfMonthNameByMonthNumber.get(closeDateToUse.month()), ...other fields... ); oList.add(o); } insert oList;