Skip to main content
I currenlty have a picklist with values 1,2,3, and 4 for the quarters. I have 2 date fields for quarter start date and quarter end date. My idea is to use process builder to generate the quarter start and end dates when the quarter is selected. But I'm getting stuck on the formula. How can I make the formula know to choose the right year. If I'm in Q4 this year how can I make the formula know to choose the following year for Q1?

 

Should I hard code in future years?

 

Q1 = January 1 - March 31

 

Q2 = April 1 - June 30

 

Q3 = July 1 - September 30

 

Q4 = October 1 - December 31
18 respuestas
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    16 jul 2020, 15:02
    Hi,

     

    This is going to the "else" result, so I woudl assume your picklist values are not Q1, Q2, Q3 or Q4.

     

    Can you take a screenshot of the picklist values in the set up area like so:

     

    Hi, This is going to the

     

    Also, for the End Date, the formula won't work, use the one with ADDMONTHS

     

    It's working fine for me