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

Hello i have a problem with this formula : CASE WHEN TO_CHAR({trandate}+75, 'Day') ='Tuesday' THEN '1' END i dont understand why i have not a result  but i have a result for TO_CHAR({trandate}+75, 'Day'  . It's working only for CASE WHEN TO_CHAR({trandate}+75, 'Day') ='Wednesday' THEN '1' END

There's no Else to return a result when not Tuesday.

*There is no Else to return a result when it's not tuesday* : I don't need to return another value because when it's tuesday I must have a result in my saved search but for a reason I don't know it only works when the day is wednesday

It wasn't clear what you were wanting and the data you were working with (if you didn't have any transactions that were 75 days from a Tuesday that is why no results, is how I read it). It works if you say LIKE 'TUESDAY%' so there must be something weird about that word.