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 how to change below to next week sunday, currently this is this week but i want as next week sunday Thanks! ? case when {duedate} &lt;= NEXT_DAY({today},'SUNDAY') then 1 else 0 end.  is the following correct - CASE
   WHEN {duedate} &lt;= NEXT_DAY({today},'SUNDAY')
   THEN DATEADD('day', 7 - DATEPART('weekday', {duedate}), {duedate})
   ELSE {duedate}
END

Just add 7 to the date you get from the next day function. You will have next week Sunday.

case when {duedate} &lt;= NEXT_DAY({today},'SUNDAY') then 1 else 0 end. is the following correct - CASE
   WHEN {duedate} &lt;= NEXT_DAY({today},'SUNDAY')
   THEN DATEADD('day', 7 - DATEPART('weekday', {duedate}), {duedate})
   ELSE {duedate}
END

case when {duedate} &lt;= NEXT_DAY(DATEADD({today}, 7, 'day'), 'SUNDAY') then 1 else 0 end

You can apply the same in a result column to see how a date is impacting before you put it in the filter.