Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
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:
Tagged:
0