Saved search formula to be applied when the date is provided as a string in a static format.

When value of trandate is in ‘YYYY/MM/DD’ format.

["formulatext: CASE WHEN TO_CHAR({trandate}, 'M/D/YYYY') <= TO_CHAR(TO_DATE('2023/7/28', 'YYYY/MM/DD'), 'M/D/YYYY') THEN 1 ELSE 0 END","is","1"]