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.
Personally, I prefer the intervalmatch in cases as these. You have more flexibility with the names of the ranges and you aren't limited to the fixed interval width of the class function. For months >12 you need an extra if statement to group all classes over 12 months together.