calculation based on date

Hello @kjou06

Thank you very much for using our plugin. Assuming the date field is the fieldname123, you can insert a calculated field in the form and enter the 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;
})()

You need only to replace fieldname123 in the previous equation with the name of the date field in your form.

Best regards.

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

Hello @kjou06

I’m sorry, but what you say is incorrect. The use of return instruction stops the evaluation of the equation returning a result, the other lines in the equation are not evaluated.

If the following condition is satisfied

if (d<='2025/04/30') return 200; 

The equation returns 200 and the second condition is never reached.

Have you tested the equation?

Best regards.

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

Hello @kjou06

You are describing a different situation. The code I recommended previously is based on your initial question, where is feasible to compare them alphabetically. But if you change the date format, you cannot compare them as texts and must convert them into date objects. In this case, the equation would be:

(function(){
let d = DATEOBJ(fieldname123, 'dd/mm/yyyy');
if (d<=DATEOBJ('30/04/2025', 'dd/mm/yyyy')) return 200;
if (d<=DATEOBJ('30/06/2025', 'dd/mm/yyyy')) return 140;
return 110;
})()

Best regards.

Thank you very much. It’s perfect