How to make system considers Meals Policy start-end date rather than its Expense Report Template one

Summary:

We have new Single Instance limit rate for Meals Policy.

Let say, existing Meals Policy has one rate RM 225 start date 01/01/2001 with no end

Our new policy let say allow max RM 500 starting from 1 July.

As we cannot edit the existing Meals Policy, we duplicated it and added as follow

Single Instance Limit Start Date End Date

RM 225 01/01/2001 30/06/2025

RM 500 01/07/2025

Then on the Expense Report Template page, we disable the old Meals Policy by 26/08/2025 (because we can't put backdate) and added new duplicated one.

Start Date End Date

old Meals Policy 01/01/2001 25/08/2025

new Meals Policy 26/08/2001

We tested by raising new expense claim. However, the result is unexpected