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

Is it possible to do a CASE WHEN like this:

CASE WHEN customdatefield IS AFTER 12/31/2020 THEN {amount} ELSE 0 END

I keep getting invalid expression error.

`CASE WHEN {customdatefield} &gt; TO_DATE( '12/31/2020', 'MM/DD/YYYY')  THEN {amount} ELSE 0 END`