Discussions
NEXT_DAY expression in Saved Search cannot accept field as second parameter?
Hello, all,
I'm trying to get the NEXT_DAY expression in a saved search formula to accept a record field as its second paramter (for "day of the week"). In other words, instead of passing a constant string value:
NEXT_DAY({startdate}, 'MONDAY')
...I'm trying to pass a field/variable.
NEXT_DAY({startdate}, {custbody_target_day_of_week})
However, no matter what I try (and I've tried a lot), I get an ERROR:Invalid Expression error for that field.
The NEXT_DAY formula is the top-level formula in a field of type: Date.
The {custbody_target_day_of_week} field is a Free-form Text field. Even so, I've tried countless manipulations of the {custbody_target_day_of_week} field to cast it to a string or char type that NEXT_DAY might accept -- but no luck. I've tried things like the following: