kjou06

Thank you very much. It’s perfect

Sorry. It actually works fine with the yyyy/mm/dd date format but if my date field is formatted in dd/mm/yyyy, it doesn’t work anymore

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