Thanks for the super fast reply but it doesn’t work because the calculation field would have to detect if the current date is between two dates.
In your equation,
(function(){
let d = CDATE(fieldname123, ‘yyyy/mm/dd’);
if (d<=’2025/04/30′) return 200; if (d<=’2025/06/30′) return 140; return 110; })() the rate remains the same if the date <= 2025/04/30 or <= 2025/06/30 since the equation does not calculate if the date is >= 2025/30/04 AND <= 2025/30/06