This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I'm trying to get a conditional date function to work within a saved search, the formula currently is

Case WHEN {today} - {transhippeddate} &lt;=14 Then 'Green' ELSE END

This is returning 0 results but the {Today} - {transhippeddate} standalone returns numeric values. Any ideas?

This case when statement is missing a value for the ELSE, so the formula doesn't know what to do with the results for anything that isn't 'Green'.

Also you might want to make sure you are using a Formula (text) field and wrap this case when statement in TO_CHAR. As an example, TO_CHAR(CASE WHEN {today} - {shipdate} &lt;=14 THEN 'Green' ELSE 'Red' END)