8 Replies Latest reply on Jan 17, 2018 8:34 AM by Lisa Lacroix

    Group months by season

    Matt Hladun

      Have tried using the month function for this, but can't get it to work. I am trying to group months into seasons using a calculation to group the months by season as seen below:

       

      Capture.PNG

      This is the calculation is unsuccessfully attempted:

      if (Month([Incident Date] = 12)) or

         (Month([Incident Date] = 1)) or (Month([Incident Date] = 2)) then 'Winter'

      elseif

          (Month([Incident Date] = 3)) or

          (Month([Incident Date] = 4)) or (Month([Incident Date] = 5)) or

          (Month([Incident Date] = 6)) then 'Spring'

      elseif

          (Month([Incident Date] = 9)) or

          (Month([Incident Date] = 10)) or (Month([Incident Date] = 11)) then 'Fall'

      END