[ad_1]
Hello @lfedele
Yes, of course. That’s possible. But, you must sum the price per day. For example, assuming the from and to dates fields are the fieldname1 and fieldname2, respectively, you can implement the equation as follows:
(function(){
var _from = MIN(fieldname1, fieldname2),
_to = MAX(fieldname1, fieldname2);
_price = 0;
while(_from < _to){
if(MONTH(_from) < 4 ) _price += 100;
else _price += 120;
_from++;
}
return _price;
})()Best regards.
