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

Hi, I'm trying to use this formula and NS does not like it. I think I need to add something around the dates. Any ideas?

*CASE WHEN {duedate} BETWEEN '01/01/2020' AND '31/12/2020' THEN {amountremaining} ELSE 0 END*

Maybe check here <https://www.abaci-us.com/netsuite-to-date-to-char-date-functions/#:~:text=NetSuite%20Saved%20Search%20Date%20functions,extract%20elements%20of%20Date%20Object.&amp;text=TO_CHAR%20function%20is%20used%20to,just%20Date%20object)%20into%20text>.

<@ULQKXHWP7> don't use between.  You need to say where the date is &gt; X and &lt; Y to create Between

I rejoiced too quickly... I see the error again. Here is how I am typing it: *CASE WHEN {duedate} &gt; '01/01/2020' AND {duedate} &lt; '31/12/2020' THEN {amountremaining} ELSE null END*

Do you think this should work?

Check these formulas to get idea, I dont expect a raw string to compare to a date, no.
<http://www.melioza.com/2015/09/netsuite-report-dates.html>

These are interesting but they don't seem to have my example of range between two exact dates

I got it working again, thanks for your help