Hi all, I have the following formula in a saved search: formula: "CASE WHEN ({startdate} <= CURRENT_DATE + 7) THEN CASE WHEN ({enddate} >= CURRENT_DATE) THEN 1 ELSE 0 END ELSE 0 END" I need to replace CURRENT_DATE with a variable, I am trying with var date = '12/14/2018'; and var date = new Date(); but no luck. Has anyone done this before?