I'm trying to create a column in a saved search showing the unfulfilled quantity between specific dates. My formula (Formula Numeric) is: CASE WHEN {trandate} IS BETWEEN '7/15/2021' AND '7/18/2021' THEN {quantity}-{quantitypicked} ELSE NULL END This throws an invalid expression error even if I take out the quotes surrounding the dates.

use a to_date function on your dates

It worked. Thank you.