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 need a netsuite saved search formula for a start date where the start date is on the second day of this month. What's my formula?

&gt;*AI generated answer (using internal Slack threads):*
To create a NetSuite saved search formula for a start date where the start date is on the second day of this month, you can use a formula (date) field type with the following formula:

```CASE WHEN TO_CHAR({startdate}, 'DD') = '02' AND TO_CHAR({startdate}, 'MM') = TO_CHAR(SYSDATE, 'MM') THEN 1 ELSE 0 END```

This formula checks if the day of the start date is the second day and if the month of the start date is the current month. If both conditions are met, it returns 1, otherwise, it returns 0.

******
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/p1555599665011300|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.85496819

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

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



Please provide your feedback on this answer.

This was very close. I had to use the Formula (Numeric) filter