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:
NEXT_DAY({startdate}, SUBSTR({custbody_target_day_of_week}, 1, 3))
NEXT_DAY({startdate}, NVL({custbody_target_day_of_week}, 'Monday'))
NEXT_DAY({startdate}, UPPER({custbody_target_day_of_week}))
Am I missing something obvious about why NEXT_DAY will not accept field values as a parameter for "day of the week"?
Thanks.
Alex McCullough