9 Replies Latest reply on Nov 22, 2016 9:41 AM by amwaterh

    Calculating season based on date ranges

    amwaterh

      Hi There,


      I would like to calculate a field called season based on the following date ranges:

      1. March 21 - June 20 = Spring

      2. June 21 - September 20 = Summer

      3. September 21 - December 20 = Fall

      4. December 21 - March 20 = Winter

       

      The year can be disregarded.  Ideally this can be set up in a calculated field type called season_automated.

       

      Thanks for your time!

      Amy