function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

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

How to calculate next meeting date based on given frequency,week and day.

Hi,

I have to write a trigger to calculate next meeting date from today. I have an object which stores input of Frequency(monthly, two month, quaterly), Day(Mon-Fri),Week (Week1 -Week 5). Based on these input how should I calculate the next meeting date from today.

example: If Frequency is "Monthly", Day is "Wednesday" and Week is "Week 3".
then I have to calculate date of next meeting which should be Wednesday of 3rd week of next month.

Please help.
Thanks!
 
Best Answer chosen by SARI4
Saravana Bharathi 1Saravana Bharathi 1
Hi,


Please try with below code.

For Reference 
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_methods_system_date.htm

Date nextMeetingDate;
if(Frequency == 'Monthly')
{
    nextMeetingDate = System.today().addMonths(1);
}
if(Week !=NULL)
{
    Date nextMeetingDateStartMonth = nextMeetingDate.toStartOfMonth();
    if(Week == 'Week 1')
    {
        nextMeetingDate = nextMeetingDateStartWeek.addDays(7);
    }
    if(Week == 'Week') 
    {
        nextMeetingDate = nextMeetingDateStartWeek.addDays(14);
    }
    if(Week == 'Week 3')
    {
        nextMeetingDate = nextMeetingDateStartWeek.addDays(21);
    }
    if(Week == 'Week 4')
    {
        nextMeetingDate = nextMeetingDateStartWeek.addDays(28);
    }
}
if(Day !=NULL)
{
    Date nextMeetingDateStartWeek = nextMeetingDate.toStartOfWeek();
    if(UserInfo.getLocale()=='en_US')
    {
        if(Day == 'Monday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(1);
        if(Day == 'Tuesday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(2);           
        if(Day == 'Wednesday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(3);
        if(Day == 'Thursday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(4);
        if(Day == 'Friday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(5);
        if(Day == 'Saturday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(6);
        if(Day == 'Sunday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(7);                               
    }
    else
    {
        if(Day == 'Monday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(7);
        if(Day == 'Tuesday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(1);           
        if(Day == 'Wednesday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(2);
        if(Day == 'Thursday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(3);
        if(Day == 'Friday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(4);
        if(Day == 'Saturday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(5);
        if(Day == 'Sunday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(6);                                   
    }
}

If it solves your problem, mark it as answer.

Thanks

All Answers

Saravana Bharathi 1Saravana Bharathi 1
Hi,


Please try with below code.

For Reference 
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_methods_system_date.htm

Date nextMeetingDate;
if(Frequency == 'Monthly')
{
    nextMeetingDate = System.today().addMonths(1);
}
if(Week !=NULL)
{
    Date nextMeetingDateStartMonth = nextMeetingDate.toStartOfMonth();
    if(Week == 'Week 1')
    {
        nextMeetingDate = nextMeetingDateStartWeek.addDays(7);
    }
    if(Week == 'Week') 
    {
        nextMeetingDate = nextMeetingDateStartWeek.addDays(14);
    }
    if(Week == 'Week 3')
    {
        nextMeetingDate = nextMeetingDateStartWeek.addDays(21);
    }
    if(Week == 'Week 4')
    {
        nextMeetingDate = nextMeetingDateStartWeek.addDays(28);
    }
}
if(Day !=NULL)
{
    Date nextMeetingDateStartWeek = nextMeetingDate.toStartOfWeek();
    if(UserInfo.getLocale()=='en_US')
    {
        if(Day == 'Monday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(1);
        if(Day == 'Tuesday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(2);           
        if(Day == 'Wednesday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(3);
        if(Day == 'Thursday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(4);
        if(Day == 'Friday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(5);
        if(Day == 'Saturday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(6);
        if(Day == 'Sunday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(7);                               
    }
    else
    {
        if(Day == 'Monday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(7);
        if(Day == 'Tuesday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(1);           
        if(Day == 'Wednesday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(2);
        if(Day == 'Thursday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(3);
        if(Day == 'Friday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(4);
        if(Day == 'Saturday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(5);
        if(Day == 'Sunday')
        nextMeetingDate = nextMeetingDateStartWeek.addDays(6);                                   
    }
}

If it solves your problem, mark it as answer.

Thanks
This was selected as the best answer
SARI4SARI4
Thanks! It really helped, I did small changes as per my requirnment.