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

How would I go about making a search that started on Thursday of every week and ended Wednesday the next week? The report needs to go out daily so I can't use the 7 days ago option and only send on Wednesdays...

This might need tweaking, but you could probably use a formula, comparing a date field against:

Thursday of this week:  `{today} + 5 - to_number(to_char({today}, 'D'))`

Wednesday of next week:  `{today} + 11 - to_number(to_char({today}, 'D'))`

alternatively, you can use `SYSDATE` instead of `{today}`:  `SYSDATE + 11 - TO_NUMBER(TO_CHAR(SYSDATE, 'D'))`

I think SYSDATE will be server timezone and {today} is user's timezone