how to have two different rates based on the dates

Hello Friends

Need advice on the fuel types and mileage rates. We have a mileage schedule with few fuel types and the mileage rates for those types. Now we have to end date couple of fuel types as of 12th June 2020, which means when a user creates an mileage expense report with the claim date before 12th June user should be able to see those fuel types and the associated rates and vice versa. We don't want to end-date the existing schedule as we have 150 plus operating units and creating the new schedule means i will have to update all