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

How to do case when condition using dates, for example,  in a formula(numeric) field you want to get amounts of transactions before a specific date something like `{trandate} &lt; '2020-10-02'`? This one didn't seem to work.

`{trandate} &lt; TO_DATE( '<tel:2020-10-0|2020-10-0>2', 'YYYY-MM-DD')`