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 have criteria of a saved search  that's basically `when {cust_date_field} - {today} BETWEEN 0 and 14 then 1 else 0` - question I have is would this be possible using `&gt;0 and &lt;=14`  in the statement in place of the "between 0 and 14"? I tried and it kept failing - was thinking maybe someone had experience and could share some thoughts as to if I was doing something wrong.

You'd need to repeat the subtraction statement twice to use `&gt;0 and &lt;=14` Something more like:

`case`
  `when {cust_date_field} - {today} &gt; 0 and`
       `{cust_date_field} - {today} &lt;=14`
  `then 1`
  `else 0`
`end`

<@UBRE35B6K> Ahhh, well that makes perfect sense. Thanks! Even though I have it working using "BETWEEN", I was still curious about how to accomplish the same result with this method. Appreciate the response!