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 {expectedreceiptdate} &lt; {today} THEN 1 else 0 END

My above expression is true even when the expected receipt date and today's date are the same. I only want to show data when today's is greater than the expected receipt date

Try putting the formula {today} - {expectedreciptdate} as a result column in your saved search. You will probably get a long decimal number instead of an integer. That's why it's causing that

Sometimes I have to use the criteria {today} - {expectedreciptdate} is not between -1 and 0 or something like that to catch the decimals

Good point. In the results column I has this which actually then shows the correct days:

TRUNC({today} - {expectedreceiptdate})

Just trying to figure out how to use this in the criteria as it complains, tried this:

`case when trunc({expectedreceiptdate})&lt;{today} then 1 else 0 end`

ah yes, that was it! parens in the wrong spot!