@MySuite the solution is as follows: formula: "CASE WHEN ({startdate} <= TO_DATE('"+ date +"', 'YYYY/MM/DD') + 21) THEN CASE WHEN ({enddate} >= CURRENT_DATE + 14) THEN 1 ELSE 0 END ELSE 0 END", where the date is a variable with a value like '2018/12/14'.