Hello There 777Psalm91,
Since it seems like you have a decent start on this one, a detailed response is probably not needed.
Try a nested IIF statement to evaluate the month value of the EmployeeStartDate and the value of the ServiceInterval, then define your desired output accordingly.
Good Luck
Since it seems like you have a decent start on this one, a detailed response is probably not needed.
Try a nested IIF statement to evaluate the month value of the EmployeeStartDate and the value of the ServiceInterval, then define your desired output accordingly.
Good Luck