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

CASE WHEN {custrecord_md_pg_payment_1_due_date} - TO_DATE({today}) &gt; 0 THEN 1 ELSE 0END

Should this be a formula text or a formula date field? custrecord field is a date field

&gt;*AI generated answer (using internal Slack threads):*
The formula you provided: `CASE WHEN {custrecord_md_pg_payment_1_due_date} - TO_DATE({today}) &gt; 0 THEN 1 ELSE 0 END` should be a formula numeric field. This is because the result of the formula is either 1 or 0, which are numeric values. 

The formula is checking if the `custrecord_md_pg_payment_1_due_date` is greater than today's date. If it is, it returns 1, otherwise it returns 0. This is a numeric comparison, hence the result should be stored in a numeric field.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1693910021429579|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.84202534

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C2C2JM29M/p1627911505001800|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.837418199

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1646840553940459|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.837302685



Please provide your feedback on this answer.