5 Replies Latest reply: Nov 15, 2012 10:10 AM by Ismael Villegas II RSS

    Grouping Based on Value within Range

    Ismael Villegas II

      I am trying to find the easiest way to group employees based on tenure. I have everyones start date and I was going to get the number of days that they have been employed by taking the current day minus the start date. I then want to join my list to the table below which would give me their tenure group.

       

      Any assistance would be great. Thank you.

      .

      TenureGrpMinDaysMaxDays
      0 to 2 Months059
      2 to 4 Months60119
      4 to 6 Months120179
      6 to 8 Months180239
      8 to 10 Months240299
      10 to 12 Months300360
      Over 12 Months3611000000