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!
Unexpected Error using CASE WHEN formula on custom Date/Time field
Hey all,
Wondering if anyone else has experienced this?
I'm trying to do a VERY simple CASE WHEN formula as a result on a transaction search. Criteria:
Type = SO
Main Line = T
Result:
Formula (text) CASE WHEN ({custbodya}-{custbodyb})>0 THEN '2' ELSE '1' END
{custbodya} and {custbodyb} are BOTH custom date/time fields.
I end up getting an unexpected error, yet:
1. When I do this with standard NS fields (on a case record, etc.), I get no error
2. The simple arithmetic of {custbodya}-{custbodyb} in its own formula DOES work. It only fails when the arithmetic is combined with the CASE WHEN.
0